Thread: index defragmentation

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

Thanks

Wei

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@{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.

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

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