Hi Peter, Thanks a lot for your reply. > What Postgres version? The WAL Writer will hibernate on Postgres 9.2+. > walwriter.c says: I am using Postgresql-9.1 shipped with Raspbian (debian for raspberry pi). > /* > * 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 In my case there will always be work at a higher frequency as the delay time - in the hope to write out multiple transactions with a single fsync, so the do-nothing case will most likely not happen. My question on the list was merely to make sure there are no side-effects when increasing this delay above what seems to be considered safe limits. However, I still wonder why this parameter is capped to 10s and whether this restriction could be lifted in future postgresql versions? Thanks & regards, Clemens -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
