Re: index defragmentation

From: Richard Huxton <dev(at)archonet(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:28
Message-ID: 200305071821.28761.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2003-05-07 17:32:22 Re: PostgreSQL Qs
Previous Message Josh Berkus 2003-05-07 17:21:17 Re: index defragmentation