Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 0CF7A632657 for ; Thu, 5 Mar 2009 14:57:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 61545-07 for ; Thu, 5 Mar 2009 14:57:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id 28A4B63486A for ; Thu, 5 Mar 2009 14:57:26 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Thu, 05 Mar 2009 12:57:25 -0600 Message-Id: <49AFCC30.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Thu, 05 Mar 2009 12:57:20 -0600 From: "Kevin Grittner" To: "Aaron Guyon" , Subject: Re: Postgres 8.3, four times slower queries? References: <2870.1236050632@sss.pgh.pa.us> <17797.1236119652@sss.pgh.pa.us> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200903/54 X-Sequence-Number: 32976 >>> Aaron Guyon wrote: > 8.3.3: 1195 ms > 8.2.12: 611 ms Could you send the non-commented lines from the postgresql.conf files from both installations? If feasible, update to the latest bug-fix version of 8.3. Also, if you haven't already done so, try setting effective_cache_size = '3GB' and random_page_cost = 2 for the 8.3 database and restart to see what kind of plan you get. -Kevin