Re: analyse question.. - Mailing list pgsql-sql

From Tom Lane
Subject Re: analyse question..
Date
Msg-id 11148.1050595493@sss.pgh.pa.us
Whole thread Raw
In response to Re: analyse question..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> On Thursday 17 Apr 2003 7:47 pm, Tom Lane wrote:
>> Rajesh Kumar Mallah <mallah@trade-india.com> writes:
>>> Do we need to analyze a table after indexing ?
>> 
>> No.

> Doesnt' it mean we shud analyze after index creation so that
> statiscs are updated?

No, because the statistics are independent of whether an index exists or
not.  You can do it in either order and get the same results.
        regards, tom lane



pgsql-sql by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: getting rid of "Adding missing FROM-clause entry...."
Next
From: Tom Lane
Date:
Subject: Re: planner question..