X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B27BED6ED8 for ; Fri, 25 Nov 2005 08:37:22 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87468-07 for ; Fri, 25 Nov 2005 12:37:24 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp101.rog.mail.re2.yahoo.com (smtp101.rog.mail.re2.yahoo.com [206.190.36.79]) by svr1.postgresql.org (Postfix) with SMTP id C3CC5D6822 for ; Fri, 25 Nov 2005 08:37:19 -0400 (AST) Received: (qmail 13527 invoked from network); 25 Nov 2005 12:37:16 -0000 Received: from unknown (HELO phlogiston.dydns.org) (a.sullivan@rogers.com@209.222.54.227 with login) by smtp101.rog.mail.re2.yahoo.com with SMTP; 25 Nov 2005 12:37:16 -0000 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 1B33140B5; Fri, 25 Nov 2005 07:37:15 -0500 (EST) Date: Fri, 25 Nov 2005 07:37:15 -0500 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: does indexes need statistics? Message-ID: <20051125123714.GA19449@phlogiston.dyndns.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.006 required=5 tests=[AWL=0.006] X-Spam-Score: 0.006 X-Spam-Level: X-Archive-Number: 200511/240 X-Sequence-Number: 23491 On Thu, Nov 24, 2005 at 07:43:28PM +0100, Mauricio Fernandez A. wrote: > Is it necesary the statistics be enabled when I create indexes or to > use them? Uh, yes, but you can't turn them off. I suspect I don't understand your question. Do you mean the "runtime statistics" section of the configuration file? If that's what you mean, then no. Those aren't the same thing as the statistical data used by the planner; the latter is updated when you run "analyse". A -- Andrew Sullivan | ajs@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler