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: