thanks tom. i wasn't sure about create index taking exclusive locks on tables too. so i could as well reindex than doing the whole _swap mess during off-peak hrs.
--- Tom Lane <[EMAIL PROTECTED]> wrote: > Shankar K <[EMAIL PROTECTED]> writes: > > ... so i then decided to do reindex online, but > > that makes exclusive lock on table which would > prevent > > writing on to tables. > > So does CREATE INDEX, so it's not clear what you're > buying with > all these pushups. > > > 2. analyze table to update stats, so that the > table > > knows about new indexes. > > You do not need to ANALYZE to get the system to > notice new indexes. > > > 4. i wish i had a rename index command to rename > _swap > > to its original index name. > > You can rename indexes as if they were tables. > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to > [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
