On Sat, Feb 1, 2014 at 3:40 PM, Clemens Eisserer <linuxhi...@gmail.com> wrote: > Something like wal_writer_delay=600s would be ideal, I can afford to > loose a 10min of data, but can't afford to get a corrupted database > after power loss.
What Postgres version? The WAL Writer will hibernate on Postgres 9.2+. walwriter.c says: /* * Number of do-nothing loops before lengthening the delay time, and the * multiplier to apply to WalWriterDelay when we do decide to hibernate. * (Perhaps these need to be configurable?) */ #define LOOPS_UNTIL_HIBERNATE 50 #define HIBERNATE_FACTOR 25 -- Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
