Robert Treat <xzilla@users.sourceforge.net> writes:
> Would it be safe to say that tables with high update rates where the
> updates do not change the indexed value would not suffer from index
> bloat?
I would expect not. If you vacuum often enough to keep the main table
size under control, the index should stay under control too.
> For example updates to non-index columns or updates that
> overwrite, but don't change the value of indexed columns; do these even
> need to touch the index?
Yes, they do. Think MVCC.
regards, tom lane
