Postgres Pro
Downloads
Home   >   mailing lists

Re: index defragmentation - Mailing list pgsql-sql

From Josh Berkus
Subject Re: index defragmentation
Date
Msg-id 200305071021.17049.josh@agliodbs.com
Whole thread Raw
In response to index defragmentation  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
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 BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: index defragmentation
Next
From: "SZŰCS Gábor"
Date:
Subject: "too clever" when creating SQL functions