Could anybody run benchmarks? Feature freeze is soon, but it would be *very nice* to fit it into 9.6 release cycle, because it greatly improves scalability on large machines. Without this patch PostgreSQL 9.6 will be significantly behind competitors like MySQL 5.7.
I have run the performance and here are the results.. With latest patch I did not see any regression at lower client count (median of 3 reading).
scale factor 1000 shared buffer 8GB readonly
ClientBasepatch
11295713068
22493125816
44631148767
32300921310062
64387623493843
128249635583513
scale factor 300 shared buffer 8GB readonly
ClientBasepatch
11453714586 --> one thread number looks little less, generally I get ~18000 (will recheck).
23470333929 --> may be run to run variance (once I get time, will recheck)
46774469069
32312575336012
64213312539056
128190139380122
Summary:
Actually with 64 client we have seen ~470,000 TPS with head also, by revering commit 6150a1b0.