Re: index defragmentation

From: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
To: Wei Weng <wweng(at)kencast(dot)com>, PostgreSQL-mailinglist <pgsql-sql(at)postgresql(dot)org>
Subject: Re: index defragmentation
Date: 2003-05-07 17:17:41
Message-ID: 200305071317.41856.darcy@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at){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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-05-07 17:21:17 Re: index defragmentation
Previous Message Josh Berkus 2003-05-07 16:57:22 Re: Unanswered Questions WAS: An unresolved performance problem.