Re: index does not improve performance

From: Milos Prudek <milos(dot)prudek(at)tiscali(dot)cz>
To: Frank Bax <fbax(at)sympatico(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: index does not improve performance
Date: 2002-02-04 10:57:07
Message-ID: 3C5E6903.21E38EA6@tiscali.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Frank Bax wrote:
>
> The "VACUUM" part of "VACUUM ANALYZE" is like "PACK" from your FoxPro days.

I knew that, since I read the fine manual :-) No harm in pointing it
out, though.

> The extra speed came from making the physical files smaller. A
> significant difference from FoxPro is that with PG, an UPDATE actually does
> a INSERT of a new row, and a DELETE of old row. You will want to perform

But I did not know this. Thanks to you, Frank and Darko!

--
Milos Prudek

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arsalan Zaidi 2002-02-04 11:10:00 Re: Distributing index's/tables/logs/etc.
Previous Message Denis Gasparin 2002-02-04 08:19:51 Re: Indices for foreign keys