Re: Postgres's Performance degrades after heavy db operation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres's Performance degrades after heavy db operation
Дата
Msg-id 580.1244483547@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgres's Performance degrades after heavy db operation  (Vick Khera <vivek@khera.org>)
Список pgsql-general
Дерево обсуждения 
Vick Khera <vivek@khera.org> writes:
> 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.

8.1's autovacuum isn't very aggressive by default.  You might want to
play around with its parameters.

            regards, tom lane

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Duplicate key issue in a transaction block
Следующее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: Any way to bring up a PG instance with corrupted data in it?