| From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: analyse question.. |
| Date: | 2003-04-17 14:56:36 |
| Message-ID: | 200304172026.36334.mallah@trade-india.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thursday 17 Apr 2003 7:47 pm, Tom Lane wrote:
> 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.
Doesnt' it mean we shud analyze after index creation so that
statiscs are updated? (as u said creating index does not touch pg_statistics).
PS: this is the same table "profile_master" abt with i have posted a different
question.
>
> regards, tom lane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rajesh Kumar Mallah | 2003-04-17 15:10:06 | Re: planner question.. |
| Previous Message | Rajesh Kumar Mallah | 2003-04-17 14:51:28 | Re: getting rid of "Adding missing FROM-clause entry...." |