Hi Robert
Many thanks for your answers.
2011/7/19 Robert Haas :
> Putting the elements in order wouldn't really help, would it? I mean,
> you'd need some kind of an index inside the hstore... which there
> isn't.
Sorry for my inprecise question. In fact elements of a hstore are
stored in order
On Mon, Jun 20, 2011 at 3:31 PM, Jon Nelson wrote:
> On Mon, Jun 20, 2011 at 11:08 AM, Tom Lane wrote:
>> Jon Nelson writes:
>>> I ran a query recently where the result was very large. The outer-most
>>> part of the query looked like this:
>>
>>>  HashAggregate  (cost=56886512.96..56886514.96 ro
On Sun, Jun 19, 2011 at 10:19 PM, Jose Ildefonso Camargo Tolosa
wrote:
> So, the question is, if I were to store 8TB worth of data into large
> objects system, it would actually make the pg_largeobject table slow,
> unless it was automatically partitioned.
I think it's a bit of an oversimplificat
On Sun, Jun 19, 2011 at 2:59 PM, Stefan Keller wrote:
> 1. Obviously the '@>' has to be used in order to let use the GiST index.
> Why is the '->' operator not supported by GiST ('->' is actually
> mentioned in all examples of the doc.)?
Because it's not a comparison operator.
> 2. Currently the
Yeb Havinga wrote:
So for the Intels it's probably also lifetime writes in GB but you'd
have to check with an Intel smart values reader to be absolutely sure.
With my 320 series drive, the LBA units are pretty clearly 32MB each.
Watch this:
root@toy:/ssd/data# smartctl --version
smartctl 5.
On 2011-07-19 13:37, Florian Weimer wrote:
Is this "Total_LBAs_Written"?
I got the same name "Total_LBAs_Written" on an 5.39 smartmontools, which
was renamed to 241 Lifetime_Writes_GiB after upgrade to 5.42. Note that
this is smartmontools new interpretation of the values, which happen to
matc
* Yeb Havinga:
> On 2011-07-19 12:47, Florian Weimer wrote:
>>
>>> It would be interesting to see if the drives also show total xyz
>>> written, and if that differs a lot too.
>> Do you know how to check that with smartctl?
> smartctl -a /dev/ should show all values. If it shows
> something that
On 2011-07-19 12:47, Florian Weimer wrote:
It would be interesting to see if the drives also show total xyz
written, and if that differs a lot too.
Do you know how to check that with smartctl?
smartctl -a /dev/ should show all values. If it shows
something that looks like garbage, it means th
* Yeb Havinga:
> On 2011-07-19 09:56, Florian Weimer wrote:
>> * Yeb Havinga:
>>
>>> The biggest drawback of 2 SSD's with supercap in hardware raid 1, is
>>> that if they are both new and of the same model/firmware, they'd
>>> probably reach the end of their write cycles at the same time, thereby
On 2011-07-19 09:56, Florian Weimer wrote:
* Yeb Havinga:
The biggest drawback of 2 SSD's with supercap in hardware raid 1, is
that if they are both new and of the same model/firmware, they'd
probably reach the end of their write cycles at the same time, thereby
failing simultaneously.
I thoug
On 07/18/2011 11:56 PM, Andy wrote:
I'm talking about after I get 2 Intel 320s, should I spend the extra
money on a RAID BBU? Adding RAID BBU in this case wouldn't improve
reliability, but does it improve performance? If so, how much
improvement can it bring?
It won't improve performance enou
* Yeb Havinga:
> The biggest drawback of 2 SSD's with supercap in hardware raid 1, is
> that if they are both new and of the same model/firmware, they'd
> probably reach the end of their write cycles at the same time, thereby
> failing simultaneously.
I thought so too, but I've got two Intel 320s
12 matches
Mail list logo