pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedindex defragmentation
4+ messages / 4 participants
[nested] [flat]
* index defragmentation
@ 2003-05-07 16:47 Wei Weng <wweng@kencast.com>
0 siblings, 3 replies; 4+ messages in thread
From: Wei Weng @ 2003-05-07 16:47 UTC (permalink / raw)
To: pgsql-sql
Does postgreSQL have some kind of utility to fix/defrag the fragmented
index?
Thanks
Wei
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: index defragmentation
@ 2003-05-07 17:17 D'Arcy J.M. Cain <darcy@druid.net>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 4+ messages in thread
From: D'Arcy J.M. Cain @ 2003-05-07 17:17 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; pgsql-sql
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: index defragmentation
@ 2003-05-07 17:21 Josh Berkus <josh@agliodbs.com>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 4+ messages in thread
From: Josh Berkus @ 2003-05-07 17:21 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: index defragmentation
@ 2003-05-07 17:21 Richard Huxton <dev@archonet.com>
parent: Wei Weng <wweng@kencast.com>
2 siblings, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2003-05-07 17:21 UTC (permalink / raw)
To: Wei Weng <wweng@kencast.com>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-05-07 17:21 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-07 16:47 index defragmentation Wei Weng <wweng@kencast.com>
2003-05-07 17:17 ` D'Arcy J.M. Cain <darcy@druid.net>
2003-05-07 17:21 ` Josh Berkus <josh@agliodbs.com>
2003-05-07 17:21 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox