Ben Chobot wrote:
Is it reading it correctly to say that the bgwriter probably wouldn't help much, because a majority of the dirty pages appear to be popular?
Yes. The background writer cleaner process only does something useful if there are pages with low usage counts it can evict. You would need to increase shared_buffers significantly before it's likely that would happen. Right now, 87% of your buffer cache has a usage count of 2 or higher, which basically means it's filled with almost nothing but the working set of data it never wants to evict unless it's for a checkpoint.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
