pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
analyse question.. 4+ messages / 2 participants [nested] [flat]
* analyse question.. @ 2003-04-17 08:21 Rajesh Kumar Mallah <mallah@trade-india.com> 0 siblings, 1 reply; 4+ messages in thread From: Rajesh Kumar Mallah @ 2003-04-17 08:21 UTC (permalink / raw) To: pgsql-sql Do we need to analyze a table after indexing ? we observed that an already analyzed table had to be re-analyzed after index creation for index usage . is it normal behaviour? regds mallah. -- 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: analyse question.. @ 2003-04-17 14:17 Tom Lane <tgl@sss.pgh.pa.us> parent: Rajesh Kumar Mallah <mallah@trade-india.com> 0 siblings, 1 reply; 4+ messages in thread From: Tom Lane @ 2003-04-17 14:17 UTC (permalink / raw) To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: analyse question.. @ 2003-04-17 14:56 Rajesh Kumar Mallah <mallah@trade-india.com> parent: Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 4+ messages in thread From: Rajesh Kumar Mallah @ 2003-04-17 14:56 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql 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. > > > 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. ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: analyse question.. @ 2003-04-17 16:04 Tom Lane <tgl@sss.pgh.pa.us> parent: Rajesh Kumar Mallah <mallah@trade-india.com> 0 siblings, 0 replies; 4+ messages in thread From: Tom Lane @ 2003-04-17 16:04 UTC (permalink / raw) To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: 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 ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-04-17 16:04 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-04-17 08:21 analyse question.. Rajesh Kumar Mallah <mallah@trade-india.com> 2003-04-17 14:17 ` Tom Lane <tgl@sss.pgh.pa.us> 2003-04-17 14:56 ` Rajesh Kumar Mallah <mallah@trade-india.com> 2003-04-17 16:04 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox