On Wed, 2007-02-28 at 09:17 -0800, Joshua D. Drake wrote:
> Bill, you are right but I believe Jim was speaking from a general
> perspective. Generally speaking you should not have to reindex, or if
> you do very rarely.
>
> I too have a couple of databases we manage that require a reindex more
> often than what would be considered normal, but a reindex is far from
> the norm itself.
>
Isn't a REINDEX still needed in the case of monotonically increasing
keys, such as in a sequence or timestamp index? I also delete tuples, so
that results in a forward-shifting range of keys.
If this is not normal, I need to re-evaluate my autovacuum settings.
Regards,
Jeff Davis