Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3A5139FA25B for ; Wed, 17 Jan 2007 11:23:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 07384-05 for ; Wed, 17 Jan 2007 11:23:36 -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 EEDF49F9FDA for ; Wed, 17 Jan 2007 11:23:42 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id C18227FDFD for ; Wed, 17 Jan 2007 10:23:41 -0500 (EST) Received: from web2.messagingengine.com ([10.202.2.211]) by out1.internal (MEProxy); Wed, 17 Jan 2007 10:23:41 -0500 Received: by web2.messagingengine.com (Postfix, from userid 99) id A383226DEA; Wed, 17 Jan 2007 10:23:41 -0500 (EST) Message-Id: <1169047421.26925.1169724395@webmail.messagingengine.com> X-Sasl-Enc: tZEGgfMosN+F2HiVwj1zT6ez8ZXelIWTYTSWmCIT2zWu 1169047421 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: <1168982580.8275.1169588211@webmail.messagingengine.com> <26412.1168983547@sss.pgh.pa.us> <1168986053.16393.1169598917@webmail.messagingengine.com> <81961ff50701161444l3f932755m5a6e15ad2d948130@mail.gmail.com> <1169002739.19758.1169636285@webmail.messagingengine.com> <1169012767.6271.7.camel@localhost.localdomain> <1169044649.19974.1169715743@webmail.messagingengine.com> <44BC14E1-2CBF-465A-AD6E-443687BBB98D@fastcrypt.com> Subject: Re: PG8.2.1 choosing slow seqscan over idx scan In-Reply-To: <44BC14E1-2CBF-465A-AD6E-443687BBB98D@fastcrypt.com> Date: Wed, 17 Jan 2007 10:23:41 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/258 X-Sequence-Number: 22859 > How much memory does the box have 2GB > Yes, it takes up space Well, I upped max_fsm_pages to 2000000 because it vacuums were failing with it set to 1500000. However, I'm now autovacuuming, which might be keeping my fsm lower. I didn't realize that setting it too high had negative effects, so I'll try to get a better handle on how large this needs to be.