I have performed a new benchmark related to my ongoing experimentation
around caching and buffer manager scalability. The benchmark tests a
minor refinement of the prototype patch previously posted [1]. The
patch itself is still very much a prototype, and does not
significantly differ from what I originally posted. The big
difference is usage_count starts at 6, and saturates at 30, plus I've
tried to reduce the impact of the prior prototype's gettimeofday()
calls by using clock_gettime() + CLOCK_MONOTONIC_COARSE. I previously
posted some numbers for a patch with just the former change.
I effectively disabled the background writer entirely here, since it
never helps. These are unlogged tables, so as to not have the outcome
obscured by checkpoint spikes during the sync phase that are more or
less inevitable here (I believe this is particularly true given the
hardware I'm using). Multiple client counts are tested, giving some
indication of the impact on scalability. The same gains previously
demonstrated in both transaction throughput and latency are once again
clearly in evidence.
I should emphasize that although I've talked a lot about LRU-K and
other more sophisticated algorithms, this proof of concept still only
adds a correlated reference period (while allowing usage_count to span
a larger range). I have yet to come up with something really
interesting, such as a patch that makes an inference about the
frequency of access of a page based on the recency of its penultimate
access (that is, a scheme that is similar to LRU-K, a scheme known to
be used in other systems [2] and thought to be widely influential).
The benchmark results are available from:
http://postgres-benchmarks.s3-website-us-east-1.amazonaws.com/collector-correlate
This report was built using pgbench-collector, my fork of
pgbench-tools. It is currently under very active development. The
largest difference between it and pgbench-tools is that it offers more
advanced reporting of operating system information, which can be
correlated with pgbench latency and TPS figures. It's hosted on
Github: https://github.com/petergeoghegan/pgbench-collector . Patches
are very much welcome.
This benchmark doesn't show very much new information. I thought that
it might be useful to have detailed operating system statistics to
work off of for each test. I believe that better benchmarking tools
will help the planned improvements to buffer manager scalability.
There is likely to be multiple angles of attack.
[1] http://www.postgresql.org/message-id/CAM3SWZRM7-qmOGMCzix5U49ndFbLS_WwTx6VJsja+bN_Li5v_A@mail.gmail.com
[2] http://db.cs.berkeley.edu/papers/fntdb07-architecture.pdf, Page 215
--
Peter Geoghegan