Re: [PERFORM] Getting query plan alternatives from query planner?

2014-03-21 Thread Atri Sharma
On Fri, Mar 21, 2014 at 1:07 PM, Stefan Keller wrote: > Hi Tom > > You wrote: > > Path alternatives are rejected > > whenever possible before moving up to the next join level, so that what > > we have rejected is actually just a plan fragment in most cases. > > Thanks for the quick answer. This s

Re: [PERFORM] Advice on testing buffer spin lock contention

2013-04-15 Thread Atri Sharma
> You will want a select only workload in which all data fits in > shared_buffers, and that doesn't do a round trip to some external driver > program for each row selected. > > I proposed a patch for pgbench to add a new transaction of this nature last > year under the subject "pgbench--new transac

[PERFORM] Advice on testing buffer spin lock contention

2013-04-14 Thread Atri Sharma
Hi all, We are working on a patch which targets the overhead of spinlock in buffer cache.In this regard, we need to exercise buffer spinlock contention on a 16 core machine. Could anyone please suggest some good methods for exercising the same? Regards, Atri Sent from my iPad -- Sent via p