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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
