Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A95499F95E3 for ; Tue, 2 Jan 2007 12:24:36 -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 05619-10 for ; Tue, 2 Jan 2007 12:24:28 -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 3C5889F939F for ; Tue, 2 Jan 2007 12:24:28 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id 0EF975AC3E for ; Tue, 2 Jan 2007 11:22:14 -0500 (EST) Received: from web2.messagingengine.com ([10.202.2.211]) by out1.internal (MEProxy); Tue, 02 Jan 2007 11:22:14 -0500 Received: by web2.messagingengine.com (Postfix, from userid 99) id EBD6826735; Tue, 2 Jan 2007 11:22:13 -0500 (EST) Message-Id: <1167754933.1316.282766279@webmail.messagingengine.com> X-Sasl-Enc: nIKNaeddOXXeBZ0ALc0vErM4dVWXXmK0jf1F9jyIGiYg 1167754933 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 Subject: Config parameters Date: Tue, 02 Jan 2007 11:22:13 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/16 X-Sequence-Number: 22617 I'm curious what parameters you guys typically *always* adjust on new PostgreSQL installs. I am working with a database that contains several large tables (10-20 million) and many smaller tables (hundreds of rows). My system has 2 GB of RAM currently, although I will be upping it to 4GB soon. My motivation in asking this question is to make sure I'm not making a big configuration no-no by missing a parameter, and also for my own checklist of parameters I should almost always set when configuring a new install. The parameters that I almost always change when installing a new system is shared_buffers, max_fsm_pages, checkpoint_segments, and effective_cache_size. Are there any parameters missing that always should be changed when deploying to a decent server?