On Wed, Apr 4, 2012 at 9:05 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> Yes, the SLRU is thrashing heavily. In this configuration, there are
> 32 CLOG buffers. I just added an elog() every time we replace a
> buffer. Here's a sample of how often that's firing, by second, on
> this test (pgbench with 32 clients):
Interesting. You've spoken at length how this hardly ever happens and
so this can't have any performance effect. That was the reason for
kicking out my patch addressing clog history, wasn't it?
Why is this pgbench run accessing so much unhinted data that is > 1
million transactions old? Do you believe those numbers? Looks weird.
Perhaps we should retest the clog history patch?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services