Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F330C9FA0BA for ; Tue, 2 Jan 2007 12:34:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 07963-07 for ; Tue, 2 Jan 2007 12:34:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 999019F939F for ; Tue, 2 Jan 2007 12:34:21 -0400 (AST) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id BA99A75011; Tue, 2 Jan 2007 16:34:20 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id E96A1FF04; Tue, 2 Jan 2007 16:34:19 +0000 (GMT) Message-ID: <459A898B.9020509@archonet.com> Date: Tue, 02 Jan 2007 16:34:19 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5.0.8 (X11/20061115) MIME-Version: 1.0 To: Jeremy Haile Cc: pgsql-performance@postgresql.org Subject: Re: Config parameters References: <1167754933.1316.282766279@webmail.messagingengine.com> In-Reply-To: <1167754933.1316.282766279@webmail.messagingengine.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/17 X-Sequence-Number: 22618 Jeremy Haile wrote: > I'm curious what parameters you guys typically *always* adjust on new > PostgreSQL installs. > The parameters that I almost always change when installing a new system > is shared_buffers, max_fsm_pages, checkpoint_segments, and > effective_cache_size. Always: work_mem, maintenance_work_mem Also consider temp_buffers and random_page_cost. A lot will depend on how much of the data you handle ends up cached. -- Richard Huxton Archonet Ltd