Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DFB022E0318 for ; Fri, 4 Jan 2008 16:55:35 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 77458-08 for ; Fri, 4 Jan 2008 16:55:28 -0400 (AST) Received: from skunk.mtbrook.bozemanpass.com (skunk.mtbrook.bozemanpass.com [69.145.82.195]) by postgresql.org (Postfix) with ESMTP id 618442E31FB for ; Fri, 4 Jan 2008 16:55:28 -0400 (AST) Received: from [69.145.82.247] (unknown [69.145.82.247]) by skunk.mtbrook.bozemanpass.com (Postfix) with ESMTP id 025EA5582B2; Fri, 4 Jan 2008 12:55:26 -0800 (PST) Message-ID: <477E9D2C.5070707@boreham.org> Date: Fri, 04 Jan 2008 13:55:08 -0700 From: David Boreham User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: James Mansion CC: Jakub Ouhrabka , pgsql-performance@postgresql.org Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores References: <477E9B3C.6040906@mansionfamily.plus.com> In-Reply-To: <477E9B3C.6040906@mansionfamily.plus.com> Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/15 X-Sequence-Number: 28254 James Mansion wrote: > Jakub Ouhrabka wrote: >> How can we diagnose what is happening during the peaks? > Can you try forcing a core from a bunch of the busy processes? (Hmm - > does Linux have an equivalent to the useful Solaris pstacks?) There's a 'pstack' for Linux, shipped at least in Red Hat distributions (and possibly others, I'm not sure). It's a shell script wrapper around gdb, so easily ported to any Linux.