Re: index does not improve performance

Поиск
Список
Период
Сортировка
От Milos Prudek
Тема Re: index does not improve performance
Дата
Msg-id 3C5E6903.21E38EA6@tiscali.cz
обсуждение исходный текст
Ответ на index does not improve performance  (Milos Prudek <milos.prudek@tiscali.cz>)
Список 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 по дате отправления:

Предыдущее
От: Trond Eivind Glomsrød
Дата:
Сообщение: Re: [HACKERS] PostgreSQL v7.2 Final Release
Следующее
От: tony
Дата:
Сообщение: Re: [HACKERS] PostgreSQL v7.2 Final Release