On Tue, Nov 22, 2016 at 9:40 PM, <ma...@kset.org> wrote: > Am I doing something wrong? Would tweaking some checkpoint parameters help > reduce the WAL volume?
The answer to this question is likely yes. wal_log_hints enforces a FPW for the first modification of a page even if that's for some hint bits. This generates traffic for OLTP types of workloads where many pages are dirtied and flushed at checkpoint. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
