On Fri, May 17, 2013 at 8:17 AM, Merlin Moncure <mmonc...@gmail.com> wrote: > On Fri, May 17, 2013 at 1:34 AM, David Rees <dree...@gmail.com> wrote: >> On Thu, May 16, 2013 at 7:46 AM, Cuong Hoang <climbingr...@gmail.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
