Postgres Pro
Downloads
Home   >   mailing lists

For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER - Mailing list pgsql-general

From Phoenix Kiula
Subject For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
Date
Msg-id e373d31e0709172200va5b3453ha0f82da687a25482@mail.gmail.com
Whole thread Raw
Responses Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Q:Aggregrating Weekly Production Data. How do you do it?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER