Re: Another question on indexes (drop and recreate) - Mailing list pgsql-performance

From John A Meinel
Subject Re: Another question on indexes (drop and recreate)
Date
Msg-id 42B8465F.1020506@arbash-meinel.com
Whole thread Raw
In response to Re: Another question on indexes (drop and recreate)  (Yves Vindevogel <yves.vindevogel@implements.be>)
Responses Re: Another question on indexes (drop and recreate)  (Yves Vindevogel <yves.vindevogel@implements.be>)
List pgsql-performance
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
=:->


Attachment

pgsql-performance by date:

Previous
From: Yves Vindevogel
Date:
Subject: Re: Another question on indexes (drop and recreate)
Next
From: PFC
Date:
Subject: Re: Do Views execute underlying query everytime ??