Yves Vindevogel wrote:
> I only add records, and most of the values are "random"
> Except the columns for dates, ....
I doubt that you would need to recreate indexes. That really only needs
to be done in pathological cases, most of which have been fixed in the
latest postgres.
If you are only inserting (never updating or deleting), the index can
never bloat, since you are only adding new stuff.
(You cannot get dead items to bloat your index if you never delete
anything.)
John
=:->