Ben Chobot wrote:
> Is there a way to tell if I really am just keeping the same few pages dirty throughout every checkpoint? I wouldn't have expected that, but given our application I suppose it is possible.
You can install pg_buffercache and look at what's in the cache to check
your theory. I have some sample queries that show neat things at
http://www.westnet.com/~gsmith/content/postgresql/bufcache.sh
--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us