On 1 July 2015 at 11:11, Amit Kapila <amit.kapil...@gmail.com> wrote:
> On Wed, Jul 1, 2015 at 1:38 PM, Simon Riggs <si...@2ndquadrant.com> wrote: > > > > On 1 July 2015 at 09:00, Amit Kapila <amit.kapil...@gmail.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