Re: index defragmentation - Mailing list pgsql-sql

From Richard Huxton
Subject Re: index defragmentation
Date
Msg-id 200305071821.28761.dev@archonet.com
Whole thread Raw
In response to index defragmentation  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
On Wednesday 07 May 2003 5:47 pm, Wei Weng wrote:
> Does postgreSQL have some kind of utility to fix/defrag the fragmented
> index?

Are you familiar with "REINDEX"? I'm not sure I'd describe what it does as
"defragmentation" but it will recreate an index. See the SQL command
reference in the manuals for details (or the admin manual I think).
--  Richard Huxton



pgsql-sql by date:

Previous
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: index defragmentation
Next
From: Josh Berkus
Date:
Subject: Re: index defragmentation