On Wed, Apr 7, 2010 at 6:56 PM, David Rees <drees76@xxxxxxxxx> wrote: >> max_fsm_pages = 16000000 >> max_fsm_relations = 625000 >> synchronous_commit = off > > You are playing with fire here. You should never turn this off unless > you do not care if your data becomes irrecoverably corrupted. That is not correct. Turning off synchronous_commit is sensible if you don't mind losing the last few transactions on a crash. What will corrupt your database is if you turn off fsync. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
