Re: [PERFORM] Slow nested loop execution on larger server

2012-02-03 Thread Robert Haas
On Fri, Dec 16, 2011 at 1:27 PM, Greg Smith wrote: > Forwarding this on from someone who may pop up on the list too.  This is a > new server that's running a query slowly.  The rate at which new semops > happen may be related.  OS is standard RHEL 5.5, kernel 2.6.18-194.32.1.el5. >  One possibly i

Re: [PERFORM] Slow nested loop execution on larger server

2012-01-05 Thread Strange, John W
Subject: Re: [PERFORM] Slow nested loop execution on larger server On Fri, Dec 16, 2011 at 11:27 AM, Greg Smith wrote: > Forwarding this on from someone who may pop up on the list too.  This > is a new server that's running a query slowly.  The rate at which new > semops happen

Re: [PERFORM] Slow nested loop execution on larger server

2011-12-16 Thread Scott Marlowe
On Fri, Dec 16, 2011 at 11:27 AM, Greg Smith wrote: > Forwarding this on from someone who may pop up on the list too.  This is a > new server that's running a query slowly.  The rate at which new semops > happen may be related.  OS is standard RHEL 5.5, kernel 2.6.18-194.32.1.el5. >  One possibly

[PERFORM] Slow nested loop execution on larger server

2011-12-16 Thread Greg Smith
Forwarding this on from someone who may pop up on the list too. This is a new server that's running a query slowly. The rate at which new semops happen may be related. OS is standard RHEL 5.5, kernel 2.6.18-194.32.1.el5. One possibly interesting part is that this is leading edge hardware: