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

2013-05-20 Thread Kevin Grittner
ach alanchi...@gmail.com 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

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 controller