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

From Tom Lane
Subject Re: analyse question..
Date
Msg-id 10379.1050589051@sss.pgh.pa.us
Whole thread Raw
In response to analyse question..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: analyse question..  (Rajesh Kumar Mallah <mallah@trade-india.com>)
List pgsql-sql
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> Do we need to analyze a table after indexing ?

No.

> we observed that an already analyzed table had to be
> re-analyzed after index creation for index usage .

I think you must have made a mistake.  Creating an index doesn't
touch pg_statistic.
        regards, tom lane



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: planner question..
Next
From: Tom Lane
Date:
Subject: Re: planner question..