On Fri, May 17, 2013 at 8:17 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > On Fri, May 17, 2013 at 1:34 AM, David Rees <drees76@xxxxxxxxx> wrote: >> On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang <climbingrose@xxxxxxxxx> wrote: >>> For our application, a few seconds of data loss is acceptable. >> >> If a few seconds of data loss is acceptable, I would seriously look at >> the synchronous_commit setting and think about turning that off rather >> than risk silent corruption with non-enterprise SSDs. > > That is not going to help. whoops -- misread your post heh (you were suggesting to use classic hard drives). yeah, that might work but it only buys you so much particuarly if there is a lot of random activity in the heap. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
