X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A7B56476368 for ; Wed, 7 May 2003 13:17:39 -0400 (EDT) Received: from druid.net (druid.net [216.126.72.98]) by postgresql.org (Postfix) with ESMTP id 1C87C47634E for ; Wed, 7 May 2003 13:17:39 -0400 (EDT) Received: by druid.net (Postfix, from userid 1000) id 4C2471C4D; Wed, 7 May 2003 13:17:42 -0400 (EDT) From: "D'Arcy J.M. Cain" To: Wei Weng , PostgreSQL-mailinglist Subject: Re: index defragmentation Date: Wed, 7 May 2003 13:17:41 -0400 User-Agent: KMail/1.5.1 References: <3EB938B8.3090905@kencast.com> In-Reply-To: <3EB938B8.3090905@kencast.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305071317.41856.darcy@druid.net> X-Spam-Status: No, hits=-38.9 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/138 X-Sequence-Number: 13303 On Wednesday 07 May 2003 12:47, Wei Weng wrote: > Does postgreSQL have some kind of utility to fix/defrag the fragmented > index? REINDEX. There is a contributed utility in contrib that allows you to do it for an entire database. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.