Re: slow query

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