-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Phoenix Kiula wrote: > 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?
If you overrun your max_fsm_pages, no: else yes; Sincerely, Joshua D. Drake > > Thanks. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG717QATb/zqfZUUQRAh6uAJ9CGXbA2BxXvMbSZP9Gv8gI9QBkXgCePhqe 6aS3fp60g7YrWECspTVcxyE= =u2o/ -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
