Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 8B424632887 for ; Sun, 28 Mar 2010 14:26:42 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92985-05 for ; Sun, 28 Mar 2010 17:26:32 +0000 (UTC) X-Greylist: delayed 00:17:43.40789 by SQLgrey-1.7.6 Received: from wizmail.org (wizmail.org [217.146.107.12]) by mail.postgresql.org (Postfix) with ESMTP id 1193B632822 for ; Sun, 28 Mar 2010 14:26:32 -0300 (ADT) Received: from ebony.jgh.adsl.wizards.co.uk ([217.146.123.59]) (from_AS 16353) by wizmail.org with esmtpsa (TLSv1:DHE-RSA-CAMELLIA256-SHA:256) (Exim 4.69) id 1Nvvym-0006i2-SO (return-path ); Sun, 28 Mar 2010 17:08:52 +0000 Message-ID: <4BAF8D1D.2050109@wizmail.org> Date: Sun, 28 Mar 2010 18:08:45 +0100 From: Jeremy Harris User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.21) Gecko/20090320 Fedora/2.0.0.21-1.fc9 Thunderbird/2.0.0.21 Mnenhy/0.7.5.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Optimizer showing wrong rows in plan References: <645d9d71003272351x766707c7sadde9aa77bc1c0d3@mail.gmail.com> <645d9d71003280011q6cf2c6d6p7279605e6e0b4235@mail.gmail.com> <645d9d71003280033l16069edcp45d9bbb0e7ed5517@mail.gmail.com> <22618.1269793661@sss.pgh.pa.us> In-Reply-To: <22618.1269793661@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201003/358 X-Sequence-Number: 38183 On 03/28/2010 05:27 PM, Tom Lane wrote: > This is intentional: the size estimates for a never-yet-analyzed > table are *not* zero. This is because people frequently create and load > up a table and then immediately query it without an explicit ANALYZE. Does the creation of an index also populate statistics? Thanks, Jeremy