Il 03/08/2016 14:12, Michael Paquier ha scritto:
> On Wed, Aug 3, 2016 at 8:07 PM, Moreno Andreo <moreno.andreo@evolu-s.it> 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.
Got it.
Thanks!
Moreno
