On Tue, Aug 29, 2017 at 1:57 AM, Mithun Cy <mithun...@enterprisedb.com> wrote: > All TPS are median of 3 runs > Clients TPS-With Patch 05 TPS-Base %Diff > 1 752.461117 755.186777 -0.3% > 64 32171.296537 31202.153576 +3.1% > 128 41059.660769 40061.929658 +2.49% > > I will do some profiling and find out why this case is not costing us > some performance due to caching overhead.
So, this shows only a 2.49% improvement at 128 clients but in the earlier message you reported a 39% speedup at 256 clients. Is that really correct? There's basically no improvement up to threads = 2 x CPU cores, and then after that it starts to improve rapidly? What happens at intermediate points, like 160, 192, 224 clients? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
