On 09/11/2015 10:31 AM, Amit Kapila wrote:
Updated comments and the patch (increate_clog_bufs_v2.patch) containing the same is attached.
I have done various runs on an Intel Xeon 28C/56T w/ 256Gb mem and 2 x RAID10 SSD (data + xlog) with Min(64,).
Kept the shared_buffers=64GB and effective_cache_size=160GB settings across all runs, but did runs with both synchronous_commit on and off and different scale factors for pgbench.
The results are in flux for all client numbers within -2 to +2% depending on the latency average.
So no real conclusion from here other than the patch doesn't help/hurt performance on this setup, likely depends on further CLogControlLock related changes to see real benefit.
Best regards, Jesper -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
