On Monday, September 24, 2012 02:53:59 PM Julien Cigar wrote: > On 09/24/2012 14:34, Andres Freund wrote: > > On Monday, September 24, 2012 02:21:09 PM Julien Cigar wrote: > >> 5) synchronous_commit = off should only be used if you have a > >> battery-backed write cache. > > > > Huh? Are you possibly confusing this with full_page_writes? > > indeed...! sorry for that > (note that you still have a (very) small chance of loosing data with > synchronous_commit = off if your server crashes between two "commit > chunks") Sure, you have a chance of loosing the last some transactions, but you won't corrupt anything. Thats the entire point of the setting ;)
Greetings, Andres -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
