Re: analyse question..

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: analyse question..
Date: 2003-04-17 14:17:31
Message-ID: 10379.1050589051@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rajesh Kumar Mallah <mallah(at)trade-india(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marco Roda 2003-04-17 14:21:36 OUTER JOIN
Previous Message Stephan Szabo 2003-04-17 14:12:37 Re: planner question..