On Thu, Nov 13, 2003 at 12:06:05 -0700,
Rick Gigger <rick(at)alpinenetworking(dot)com> wrote:
>
> Is REINDEX something that needs to be done on a periodic basis?
In version prior to 7.4 some patterns of use will require periodic
reindexing. The problem case is when the index column monoticly
increases (or decreases) and old values eventually get deleted.
In this case the index blocks for the deleted values don't get
reused and the size of the index will continually grow.