]> granicus.if.org Git - postgresql/commit
Increase maximum number of clog buffers.
authorAndres Freund <andres@anarazel.de>
Fri, 8 Apr 2016 15:18:52 +0000 (08:18 -0700)
committerAndres Freund <andres@anarazel.de>
Fri, 8 Apr 2016 15:25:59 +0000 (08:25 -0700)
commit5364b357fb115ed4dc7174085d8f59d9425638dd
treea1a6b88c1d12efad2801a68b8112f2d195ddfb89
parent25fe8b5f1ac93c3ec01519854e4f554b2e57a926
Increase maximum number of clog buffers.

Benchmarking has shown that the current number of clog buffers limits
scalability. We've previously increased the number in 33aaa139, but
that's not sufficient with a large number of clients.

We've benchmarked the cost of increasing the limit by benchmarking worst
case scenarios; testing showed that 128 buffers don't cause a
regression, even in contrived scenarios, whereas 256 does

There are a number of more complex patches flying around to address
various clog scalability problems, but this is simple enough that we can
get it into 9.6; and is beneficial even after those patches have been
applied.

It is a bit unsatisfactory to increase this in small steps every few
releases, but a better solution seems to require a rewrite of slru.c;
not something done quickly.

Author: Amit Kapila and Andres Freund
Discussion: CAA4eK1+-=18HOrdqtLXqOMwZDbC_15WTyHiFruz7BvVArZPaAw@mail.gmail.com
src/backend/access/transam/clog.c