Re: index defragmentation - Mailing list pgsql-sql

From D'Arcy J.M. Cain
Subject Re: index defragmentation
Date
Msg-id 200305071317.41856.darcy@druid.net
Whole thread Raw
In response to index defragmentation  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
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 <darcy@{druid|vex}.net>   |  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.



pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Unanswered Questions WAS: An unresolved performance problem.
Next
From: Richard Huxton
Date:
Subject: Re: index defragmentation