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
Met vriendelijke groeten,
Bien à vous,
In response to
pgsql-performance by date
|Next:||From: Oliver Crosby||Date: 2005-06-21 19:46:03|
|Subject: Prepared statements vs. Stored Procedures|
|Previous:||From: Kjell Tore Fossbakk||Date: 2005-06-21 19:09:48|
|Subject: Querying 19million records very slowly|