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