Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4FB489FA434 for ; Tue, 2 Jan 2007 13:08:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 41654-01 for ; Tue, 2 Jan 2007 13:08:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by postgresql.org (Postfix) with ESMTP id 7887B9FA334 for ; Tue, 2 Jan 2007 13:08:39 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id DDB1D5A51F for ; Tue, 2 Jan 2007 12:06:24 -0500 (EST) Received: from web1.messagingengine.com ([10.202.2.210]) by out1.internal (MEProxy); Tue, 02 Jan 2007 12:06:24 -0500 Received: by web1.messagingengine.com (Postfix, from userid 99) id CB6DC2A92B; Tue, 2 Jan 2007 12:06:24 -0500 (EST) Message-Id: <1167757584.31784.282774689@webmail.messagingengine.com> X-Sasl-Enc: yreCaqnyxo4kkabEM4WzgiULxUmKuCaGWTSKBwtjRC8Y 1167757584 From: "Jeremy Haile" To: pgsql-performance@postgresql.org Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface References: <1167754933.1316.282766279@webmail.messagingengine.com> <459A898B.9020509@archonet.com> Subject: Re: Config parameters In-Reply-To: <459A898B.9020509@archonet.com> Date: Tue, 02 Jan 2007 12:06:24 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/19 X-Sequence-Number: 22620 What is a decent default setting for work_mem and maintenance_work_mem, considering I am regularly querying tables that are tens of millions of rows and have 2-4 GB of RAM? Also - what is the best way to determine decent settings for temp_buffers and random_page_cost? On Tue, 02 Jan 2007 16:34:19 +0000, "Richard Huxton" said: > 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