Re: index defragmentation

From: Josh Berkus <josh(at)agliodbs(dot)com>
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:21:17
Message-ID: 200305071021.17049.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Wei,

> Does postgreSQL have some kind of utility to fix/defrag the fragmented
> index?

Yes. See REINDEX under "SQL Commands" in the postgresql docs.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-05-07 17:21:28 Re: index defragmentation
Previous Message D'Arcy J.M. Cain 2003-05-07 17:17:41 Re: index defragmentation