Re: index does not improve performance - Mailing list pgsql-general

From Milos Prudek
Subject Re: index does not improve performance
Date
Msg-id 3C5E6903.21E38EA6@tiscali.cz
Whole thread Raw
In response to index does not improve performance  (Milos Prudek <milos.prudek@tiscali.cz>)
List 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



pgsql-general by date:

Previous
From: Trond Eivind Glomsrød
Date:
Subject: Re: [HACKERS] PostgreSQL v7.2 Final Release
Next
From: tony
Date:
Subject: Re: [HACKERS] PostgreSQL v7.2 Final Release