Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: POC: Cache data in GetSnapshotData()
Date
Msg-id CA+TgmoYVdqPwsY_VpQoP4O2ZtQJ2-AOfJ1oMnK5Gi2EbMqE=BQ@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()
Re: POC: Cache data in GetSnapshotData()
List pgsql-hackers
Tree view
On Wed, Mar 16, 2016 at 4:40 AM, Mithun Cy <mithun.cy@enterprisedb.com> wrote:

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


Whoa.  At 64 clients, we're hardly getting any benefit, but then by 88 clients, we're getting a huge benefit.  I wonder why there's that sharp change there.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Pushdown target list below gather node (WAS Re: WIP: Upper planner pathification)
Next
From: Andres Freund
Date:
Subject: Re: POC: Cache data in GetSnapshotData()