Re: Postgres's Performance degrades after heavy db operation

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Postgres's Performance degrades after heavy db operation
Дата
Msg-id 2968dfd60906080925r42c1a3ddk8728c4a653a1afb6@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres's Performance degrades after heavy db operation  ("Preeti Khurana" <preeti.khurana@globallogic.com>)
Ответы Re: Postgres's Performance degrades after heavy db operation
Список pgsql-general
Дерево обсуждения 
On Mon, Jun 8, 2009 at 9:38 AM, Preeti
Khurana<preeti.khurana@globallogic.com> wrote:
> Any ideas/pointers on what could be making the DB slow after all these heavy
> operations being performed?

It seems autovacuum is not running often enough.  You may wish to
include vacuum in your data update/delete programs so that it runs
after some number of those operations.

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

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Postgres's Performance degrades after heavy db operation
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Duplicate key issue in a transaction block