Re: [PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-20 Thread Merlin Moncure
On Mon, May 20, 2013 at 3:57 PM, Tomas Vondra wrote: > But yes, I do agree that the provider should be ashamed for not > providing reliable SSDs in the first place. Getting reliable SSDs should > be the first option - all these suggestions are really just workarounds > of this rather simple issue.

Re: [PERFORM] Reliability with RAID 10 SSD and Streaming Replication

2013-05-20 Thread Tomas Vondra
On 20.5.2013 05:00, Greg Smith wrote: > On 5/16/13 8:06 PM, Tomas Vondra wrote: >> Have you considered using a UPS? That would make the SSDs about as >> reliable as SATA/SAS drives - the UPS may fail, but so may a BBU unit on >> the SAS controller. > > That's not true at all. Any decent RAID cont

Re: [PERFORM] statistics target for columns in unique constraint?

2013-05-20 Thread Kevin Grittner
ach wrote: > One quick follow up since I'm expecting y'all might know:  Do the > statistics targets actually speed performance on an index search > itself; the actual lookup?  Or are the JUST to inform the planner > towards the best pathway decision? Since the statistics are just a random sampli