X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2FD77D1B17A for ; Wed, 4 Aug 2004 02:35:22 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14425-04 for ; Wed, 4 Aug 2004 05:34:23 +0000 (GMT) Received: from mta2.rdslink.ro (mta2.rdslink.ro [193.231.236.124]) by svr1.postgresql.org (Postfix) with ESMTP id 60B04D1B1B4 for ; Wed, 4 Aug 2004 02:32:48 -0300 (ADT) Received: (qmail 10695 invoked from network); 4 Aug 2004 08:27:22 -0000 Received: from unknown (HELO mail.rdslink.ro) (193.231.236.20) by mta2.rdslink.ro with DES-CBC3-SHA encrypted SMTP; 4 Aug 2004 08:27:22 -0000 Received: (qmail 23450 invoked from network); 4 Aug 2004 05:31:44 -0000 Received: from unknown (HELO ?81.196.83.211?) (81.196.83.211) by mail.rdslink.ro with SMTP; 4 Aug 2004 05:31:44 -0000 Subject: Re: [PERFORM] NOT IN query takes forever From: Marius Andreiana To: pgsql-general In-Reply-To: <410FCB3B.5050300@bigfoot.com> References: <6EE64EF3AB31D5448D0007DD34EEB34101AF1A@Herge.rcsinc.local> <1091548963.6915.2.camel@marte.biciclete.ro> <410FCB3B.5050300@bigfoot.com> Content-Type: text/plain Organization: Galuna S.R.L. Date: Wed, 04 Aug 2004 08:40:52 +0300 Message-Id: <1091598052.2647.7.camel@marte.biciclete.ro> Mime-Version: 1.0 X-Mailer: Evolution 1.5.9.1 (1.5.9.1-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200408/73 X-Sequence-Number: 63628 On Tue, 2004-08-03 at 19:28 +0200, Gaetano Mendola wrote: > > With > > shared_buffers = 3000 # min 16, at least max_connections*2, 8KB each > > sort_mem = 128000 # min 64, size in KB > > 128 MB for sort_mem is too much, consider that in this way each backend can > use 128 MB for sort operations... > Also shared_buffers = 3000 means 24MB that is not balanced with the 128MB > needed for sort... > Try to bump up 128 MB for shared_buffer ( may be you need to instruct your > OS to allow that ammount of shared memory usage ) and 24MB for sort_mem. Thanks for the advice. I increased shmmax to allow shared_buffers to be 128mb and set sort_mem to 24mb. -- Marius Andreiana Galuna - Solutii Linux in Romania http://www.galuna.ro