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")
Greetings, Andres
-- No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced.
<<attachment: jcigar.vcf>>
-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance