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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly