Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7B5DB9FA38F for ; Thu, 26 Oct 2006 16:08:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05574-01 for ; Thu, 26 Oct 2006 16:08:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id A35E99FB259 for ; Thu, 26 Oct 2006 16:08:44 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 9B06B5643A; Thu, 26 Oct 2006 14:08:43 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 26 Oct 2006 14:08:38 -0500 Date: Thu, 26 Oct 2006 14:08:38 -0500 From: "Jim C. Nasby" To: Mark Lonsdale Cc: "Joshua D. Drake" , Richard Huxton , pgsql-performance@postgresql.org Subject: Re: Configuration Issue ? Message-ID: <20061026190837.GC26892@nasby.net> References: <673ECBB77DA91F47AD4902A5FD73BCE4BA3AC6@mail3> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <673ECBB77DA91F47AD4902A5FD73BCE4BA3AC6@mail3> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061026:mark.lonsdale@wysdm.com::Gcra5BogoMLhDAu9:00000000000000 0000000000000000000000003oZJ X-Hashcash: 1:20:061026:jd@commandprompt.com::cfaO9kMzCHN7EPDc:00000000000000000 0000000000000000000000009gNR X-Hashcash: 1:20:061026:dev@archonet.com::3zN768Zdi0N3Ws6E:01VQt X-Hashcash: 1:20:061026:pgsql-performance@postgresql.org::9EhHwM6J4/jSDrs5:00000 00000000000000000000000039g9 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.079 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/560 X-Sequence-Number: 21689 On Wed, Oct 25, 2006 at 05:31:29PM -0400, Mark Lonsdale wrote: > Set my sort_mem to 8192 You really need to look at what your workload is before trying to tweak sort_mem. With 8G of memory, sort_mem=400000 (~400MB) with only 10 active connections might be a good setting. It's usually better to get a sort to fit into memory than spill to disk. Since you never mentioned what kind of workload you have or how many active connections there are, it's pretty much impossible to make a recommendation on that setting. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)