Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 813501337B71 for ; Wed, 27 Oct 2010 14:02:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 14244-09 for ; Wed, 27 Oct 2010 17:02:47 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from manuel.natserv.net (p65-147.acedsl.com [66.114.65.147]) by mail.postgresql.org (Postfix) with ESMTP id 53BF31337B64 for ; Wed, 27 Oct 2010 14:02:47 -0300 (ADT) Received: from shelca (zoraida.natserv.net [66.114.65.147]) by manuel.natserv.net (Postfix) with ESMTP id 441F3FA30; Wed, 27 Oct 2010 13:02:47 -0400 (EDT) References: <21877.1288195786@sss.pgh.pa.us> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Tom Lane Cc: Pgsql performance Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds Date: Wed, 27 Oct 2010 13:02:47 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.59 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_RP_RNBL=1.31 X-Spam-Level: X-Archive-Number: 201010/479 X-Sequence-Number: 40897 Tom Lane writes: > Please provide a self-contained test case for this. In testing here, > 8.4 can still figure out that it ought to use an indexscan against the > large table ... so there is some aspect of your tables that you're not > showing us. It is possible, and very likely, that it is an issue with the distribution of values. The data is 40GB+ and the largest table is 200M+ rows.. Setting a standalone setup may be difficult, but what we could do is something like webex where you, or someone else we would trust, would connect to a web conference and tell us what to type.