Re: [PERFORM] hstore - Implementation and performance issues around its operators

2011-07-19 Thread Stefan Keller
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

Re: [PERFORM] bad plan: 8.4.8, hashagg, work_mem=1MB.

2011-07-19 Thread Robert Haas
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

Re: [PERFORM] Large rows number, and large objects

2011-07-19 Thread Robert Haas
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

Re: [PERFORM] hstore - Implementation and performance issues around its operators

2011-07-19 Thread Robert Haas
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

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Greg Smith
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.

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Yeb Havinga
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

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Florian Weimer
* 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

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread 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 looks like garbage, it means th

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Florian Weimer
* 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

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread 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 failing simultaneously. I thoug

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Greg Smith
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

Re: [PERFORM] BBU still needed with SSD?

2011-07-19 Thread Florian Weimer
* 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