On Thu, Jan 5, 2012 at 4:04 PM, Robert Haas <robertmh...@gmail.com> wrote:
> It appears to me that increasing the number of CLOG buffers reduced > the severity of the latency spikes considerably. In the last 100 > seconds, for example, master has several spikes in the 500-700ms > range, but with 32 CLOG buffers it never goes above 400 ms. Also, the > number of points associated with each spike is considerably less - > each spike seems to affect fewer transactions. So it seems that at > least on this machine, increasing the number of CLOG buffers both > improves performance and reduces latency. I believed before that the increase was worthwhile and now even more so. Let's commit the change to 32. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
