Postgres Pro
Downloads
Home   >   mailing lists

Re: POC: Cache data in GetSnapshotData() - Mailing list pgsql-hackers

From Mithun Cy
Subject Re: POC: Cache data in GetSnapshotData()
Date
Msg-id CAD__OujrdwQdJdoVHahQLDg-6ivu6iBCi9iJ1qPu6AtUQpL4UQ@mail.gmail.com
Whole thread Raw
In response to Re: POC: Cache data in GetSnapshotData()  (Mithun Cy <mithun.cy@enterprisedb.com>)
Responses Re: POC: Cache data in GetSnapshotData()  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view
On Thu, Mar 3, 2016 at 6:20 AM, Mithun Cy <mithun.cy@enterprisedb.com> wrote:
> I will continue to benchmark above tests with much wider range of clients.

Latest Benchmarking shows following results for unlogged tables.

clientsBASEONLY CLOG CHANGES% IncreaseCLOG CHANGES + SAVE SNAPSHOT% Increase
11198.3263371328.06965610.82704393571234.0783422.9834948875
3237455.18172738295.2505192.242864013141023.1262939.5259037641
6448838.01645150675.8458853.763112361151662.8143195.7840143259
8836878.18776653173.57736344.187067163956025.45491751.9203038731
12835901.53777352026.02409844.913079843453864.48673350.0339263281
25628130.35440246793.13415666.343919764746817.0460266.4289235427

Performance diff in 1 client seems just a run to run variance.

--
Thanks and Regards
Mithun C Y

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: multivariate statistics v14
Next
From: Fabien COELHO
Date:
Subject: Re: pgbench stats per script & other stuff