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