Benjamin Krajmalnik wrote:
So, if I understand correctly, I should strive for a relative increase in buffers_clean to buffers_backend
Right. Buffers written by a backend are the least efficient way to get data out of the buffer cache, because the client running into that is stuck waiting for a write call before it can use the resuling free block. You want to avoid those in favor of checkpoint and background-writer cleaner writes instead.
-- Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
