For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Date: 2007-09-18 05:00:31
Message-ID: e373d31e0709172200va5b3453ha0f82da687a25482@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The manual is vague. Several threads about this, in language that is
ambiguous to me.

So a YES/NO question:

Q: To get rid of index bloat, is a VACUUM ANALYZE enough? Or must I
reindex/cluster indexes?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-09-18 05:14:56 Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Previous Message Ow Mun Heng 2007-09-18 04:34:25 Q:Aggregrating Weekly Production Data. How do you do it?