On Dec 6, 2005, at 12:44 PM, Ameet Kini wrote:
> I have a question on postgres's performance tuning, in particular, the
> vacuum and reindex commands. Currently I do a vacuum (without full)
> on all
> of my tables. However, its noted in the docs (e.g.
> http://developer.postgresql.org/docs/postgres/routine-reindex.html)
> and on the lists here that indexes may still bloat after a while
> and hence
> reindex is necessary. How often do people reindex their tables out
Why would you be running a version older than 7.4? Index bloat is
mostly a non-issue in recent releases of pg.