Re: Another question on indexes (drop and recreate)

Ok, tnx !!

On 21 Jun 2005, at 18:54, John A Meinel wrote:

> 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
> =:->
>
>
Met vriendelijke groeten,
Bien à vous,
Kind regards,

Yves Vindevogel
Implements