Re: Reducing ClogControlLock contention

On 1 July 2015 at 11:11, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:

> On Wed, Jul 1, 2015 at 1:38 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> >
> > On 1 July 2015 at 09:00, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >>
> >>
> >> I think it will be better to partition it or use it in some other way
> to avoid
> >> two concurrent writers block at it, however if you want to first see the
> >> test results with this, then that is also okay.
> >
> >
> > Many updates would be on same page, so partitioning it would need to be
> at least 4-way to be worth doing. Maybe we could stripe into 512 bye pages.
> >
>
> Sure, it makes sense to try that way, once you have that ready, I can
> try this out along with ProcArrayLock patch to see the impact.
>

Seems sensible to measure what the new point of contention is with both
before doing anything further.

--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services