Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 31DCC2E2FBD for ; Thu, 3 Jan 2008 15:51:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26545-09-2 for ; Thu, 3 Jan 2008 15:51:52 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 413D32E3217 for ; Thu, 3 Jan 2008 15:51:06 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id m03JowbY094544 for ; Thu, 3 Jan 2008 15:50:58 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id m03JQOQb082167 for pgsql-performance@postgresql.org; Thu, 3 Jan 2008 15:26:24 -0400 (AST) (envelope-from news) From: Jakub Ouhrabka X-Newsgroups: pgsql.performance Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores Date: Thu, 03 Jan 2008 20:26:30 +0100 Organization: Hub.Org Networking Services Lines: 16 Message-ID: References: <477D0D00.9040206@aeccom.com> <20080103183118.GA14593@alvh.no-ip.org> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) In-Reply-To: <20080103183118.GA14593@alvh.no-ip.org> To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/11 X-Sequence-Number: 28250 Alvaro, >>> - do an UNLISTEN if possible >> Yes, we're issuing unlistens when appropriate. > > You are vacuuming pg_listener periodically, yes? Not that this seems > to have any relationship to your problem, but ... yes, autovacuum should take care of this. But looking forward for multiple-workers in 8.3 as it should help us during high load periods (some tables might wait too long for autovacuum now - but it's not that big problem for us...). Thanks for great work! Kuba