X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 75AC5D1C4EC; Tue, 29 Jul 2003 02:21:35 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 36266-04; Mon, 28 Jul 2003 23:20:41 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 76B80D1C4EB; Mon, 28 Jul 2003 23:21:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h6T2LbQ3017555; Mon, 28 Jul 2003 22:21:37 -0400 (EDT) To: Shankar K Cc: pgsql-performance@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Rebuild indexes In-reply-to: <20030728212905.79549.qmail@web21102.mail.yahoo.com> References: <20030728212905.79549.qmail@web21102.mail.yahoo.com> Comments: In-reply-to Shankar K message dated "Mon, 28 Jul 2003 14:29:05 -0700" Date: Mon, 28 Jul 2003 22:21:37 -0400 Message-ID: <17554.1059445297@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/281 X-Sequence-Number: 9621 Shankar K 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