On Wed, Aug 3, 2016 at 8:07 PM, Moreno Andreo <moreno.andreo@xxxxxxxxxx> wrote: > Should I keep fsync off? I'd think it would be better leaving it on, right? >From the docs: https://www.postgresql.org/docs/9.6/static/runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS While turning off fsync is often a performance benefit, this can result in unrecoverable data corruption in the event of a power failure or system crash. Thus it is only advisable to turn off fsync if you can easily recreate your entire database from external data. So if you care about your data, that's to set in any case to on, as is full_page_writes. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
