Re: performance

Поиск
Список
Период
Сортировка
От missive@frontiernet.net (Lee Harr)
Тема Re: performance
Дата
Msg-id 9j7ieq$1uic$1@node21.cwnet.roc.gblx.net
обсуждение исходный текст
Ответ на performance  ("Zhan Yi" <yi_zhan@hotmail.com>)
Список pgsql-bugs
Дерево обсуждения 
On Sat, 30 Jun 2001 13:10:17 +0800, Zhan Yi <yi_zhan@hotmail.com> wrote:
> I found performance problem.
>
> createdb            speed fast
>
> after many inserts, updates then delete all from tables and redo the same
> thing
>                     speed degrade
>
> drop table and rebuild table redo operations
>                     speed fast


Make sure you read the manual regarding VACUUM. This sounds like
it could be related to needing to VACUUM your tables.

The good news is that it looks like 7.2 will have a much better
way of dealing with the need to VACUUM.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Bob Soeters"
Дата:
Сообщение: Re: Two foreign keys in one table both referencing same record in primary table gives error on update of primary table
Следующее
От: missive@frontiernet.net (Lee Harr)
Дата:
Сообщение: check contraint allows illegal value?