diff options
author | Andres Freund <andres@anarazel.de> | 2016-04-08 08:18:52 -0700 |
---|---|---|
committer | Andres Freund <andres@anarazel.de> | 2016-04-08 08:25:59 -0700 |
commit | 5364b357fb115ed4dc7174085d8f59d9425638dd (patch) | |
tree | a1a6b88c1d12efad2801a68b8112f2d195ddfb89 /src/backend/access/gist/gistbuild.c | |
parent | 25fe8b5f1ac93c3ec01519854e4f554b2e57a926 (diff) | |
download | postgresql-5364b357fb115ed4dc7174085d8f59d9425638dd.tar.gz |
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
Diffstat (limited to 'src/backend/access/gist/gistbuild.c')
0 files changed, 0 insertions, 0 deletions