Skip site navigation (1) Skip section navigation (2)

Re: Another question on indexes (drop and recreate)

From: Yves Vindevogel <yves(dot)vindevogel(at)implements(dot)be>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Another question on indexes (drop and recreate)
Date: 2005-06-21 19:30:50
Message-ID: 3ac5308f2b422062e26c7eae705121a9@implements.be (view raw or flat)
Thread:
Lists: pgsql-performance
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


Attachment: Pasted Graphic 2.tiff
Description: image/tiff (5.6 KB)

In response to

pgsql-performance by date

Next:From: Oliver CrosbyDate: 2005-06-21 19:46:03
Subject: Prepared statements vs. Stored Procedures
Previous:From: Kjell Tore FossbakkDate: 2005-06-21 19:09:48
Subject: Querying 19million records very slowly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group