Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 3936B6503A6 for ; Fri, 12 Dec 2008 14:48:13 -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 30532-03 for ; Fri, 12 Dec 2008 14:48:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from elite.newx.com.br (newx.com.br [74.55.91.162]) by mail.postgresql.org (Postfix) with ESMTP id A6B106502F0 for ; Fri, 12 Dec 2008 14:48:05 -0400 (AST) Received: from [201.37.110.31] by elite.newx.com.br with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.68) (envelope-from ) id 1LBD3D-0007Yx-SZ; Fri, 12 Dec 2008 16:47:48 -0200 Message-ID: <4942B128.3020706@timbira.com> Date: Fri, 12 Dec 2008 16:44:56 -0200 From: Euler Taveira de Oliveira User-Agent: Thunderbird 2.0.0.18 (X11/20081126) MIME-Version: 1.0 To: Robert Haas CC: Kevin Grittner , Nathan Boley , Tom Lane , Josh Berkus , "jd@commandprompt.com" , Gregory Stark , Vladimir Sitnikov , Greg Smith , pgsql-hackers@postgresql.org Subject: Re: benchmarking the query planner References: <603c8f070812061019r5aca3aajeaa5493b11c5feff@mail.gmail.com> <1d709ecc0812111354m2f5a7ba5gebc9e1d50b9de913@mail.gmail.com> <12251.1229034420@sss.pgh.pa.us> <1d709ecc0812111447m7b48bf4eg1b74e454ee3e7b7b@mail.gmail.com> <6fa3b6e20812111612m74555e44sfd3ef0ce5431ea9d@mail.gmail.com> <14209.1229041816@sss.pgh.pa.us> <6fa3b6e20812111735s193b4d70lb2864abf279ede9b@mail.gmail.com> <15086.1229046610@sss.pgh.pa.us> <6fa3b6e20812111839l29b851e7v409470aee8ed7785@mail.gmail.com> <49423C06.EE98.0025.0@wicourts.gov> <603c8f070812120835x7a6b7588icdf6e876239a80d1@mail.gmail.com> In-Reply-To: <603c8f070812120835x7a6b7588icdf6e876239a80d1@mail.gmail.com> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - elite.newx.com.br X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - timbira.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/986 X-Sequence-Number: 129615 Robert Haas escreveu: >> Which raises the issue, if we could get better statistics by passing >> the whole table, why not do that when VACUUM ANALYZE is run? > > I think the reason is "because the next autovacuum would undo it". > Ok, but even if autovacuum will undo it, almost-static-dataset would benefit from this feature because (i) autovacuum won't often trigger this table or (ii) you disabled the autovacuum on that table. > Perhaps a table-level option to scan the whole table instead of > estimating would be appropriate? > ANALYZE FULL foo ? -- Euler Taveira de Oliveira http://www.timbira.com/