Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 546622E3113 for ; Fri, 4 Jan 2008 16:44:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 38930-01-8 for ; Fri, 4 Jan 2008 16:44:06 -0400 (AST) Received: from pih-relay08.plus.net (pih-relay08.plus.net [212.159.14.134]) by postgresql.org (Postfix) with ESMTP id 5285B2E2E6C for ; Fri, 4 Jan 2008 16:44:27 -0400 (AST) Received: from [80.229.150.39] (helo=mansionfamily.plus.com) by pih-relay08.plus.net with esmtp (Exim) id 1JAtOy-0000ju-ER for pgsql-performance@postgresql.org; Fri, 04 Jan 2008 20:44:24 +0000 Received: from [192.168.0.87] ([192.168.0.87]:2254) by mansionfamily.plus.com with [XMail 1.22 ESMTP Server] id for from ; Fri, 4 Jan 2008 20:50:11 -0000 Message-ID: <477E9B3C.6040906@mansionfamily.plus.com> Date: Fri, 04 Jan 2008 20:46:52 +0000 From: James Mansion Organization: MsgWare User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Jakub Ouhrabka CC: pgsql-performance@postgresql.org Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores References: In-Reply-To: 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/14 X-Sequence-Number: 28253 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?) James