From: John A Meinel <john@arbash-meinel.com>
To: Yves Vindevogel <yves.vindevogel@implements.be>
Cc: pgsql-performance@postgresql.org
Subject: Re: Another question on indexes (drop and recreate)
Date: Tue, 21 Jun 2005 11:54:55 -0500
Message-ID: <42B8465F.1020506@arbash-meinel.com> (raw)
In-Reply-To: <09f30bc29a91c94eecaf7f70aa0c8399@implements.be>
References: <098952ec5af9b040acb9b6b5af743abd@implements.be>
<42B830B3.6060902@arbash-meinel.com>
<821370985653dc1f4166ca634f642ce2@implements.be>
<42B83708.2050706@arbash-meinel.com>
<09f30bc29a91c94eecaf7f70aa0c8399@implements.be>
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
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, yves.vindevogel@implements.be
Subject: Re: Another question on indexes (drop and recreate)
In-Reply-To: <42B8465F.1020506@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox