On 17 January 2012 17:37, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > I found it very helpful to reduce wal_writer_delay in pgbench tests, when > running with synchronous_commit=off. The reason is that hint bits don't get > set until the commit record is flushed to disk, so making the flushes more > frequent reduces the contention on the clog. However, Simon made async > commits nudge WAL writer if the WAL page fills up, so I'm not sure how > relevant that experience is anymore.
It's quite possible that the WAL Writer will spin continuously, if given enough work to do, with this patch. Although it's hard to tell from the graph I sent, there is a modest improvement in TPS for even a single client. See the tables in the PDF. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers