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__Ouic1Tvnwqm6Wf6j7Cz1Kk1DQgmy0isC7=OgX+3JtfGk9g@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 10, 2016 at 1:36 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
>Do you think it makes sense to check the performance by increasing CLOG buffers (patch for same is posted in Speed up Clog thread [1]) >as that also relieves contention on CLOG as per the tests I have done?

Along with clog patches and save snapshot, I also applied Amit's increase clog buffer patch. Below is the benchmark results.

clientsBASE+ WITH INCREASE IN CLOG BUFFER Patch% Increase
11198.3263371275.4619556.4369458985
3237455.18172741239.1359310.102618726
6448838.01645156362.16362615.4063324471
8836878.18776658217.92413857.8654691695
12835901.53777358239.78398262.22086182
25628130.35440256417.133939100.5560723934


--
Thanks and Regards
Mithun C Y

pgsql-hackers by date:

Previous
From: konstantin knizhnik
Date:
Subject: Re: Applying logical replication changes by more than one process
Next
From: "Constantin S. Pan"
Date:
Subject: Re: [WIP] speeding up GIN build with parallel workers