Re: Autovacuum in postgres.

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Autovacuum in postgres.
Дата
Msg-id AANLkTinamjCzg2L6F1jtK0Ukx02BjItDP7bOOyXgDQUP@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum in postgres.  (venu madhav <venutaurus539@gmail.com>)
Список pgsql-performance
On Thu, May 27, 2010 at 9:01 AM, venu madhav <venutaurus539@gmail.com> wrote:
> Thanks for the reply..
>            I am using postgres 8.01 and since it runs on a client box, I
> can't upgrade it. I've set the auto vacuum nap time to 3600 seconds.

You've pretty much made autovac run every 5 hours with that setting.
What was wrong with the original settings?  Just wondering what
problem you were / are trying to solve here.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: How to insert a bulk of data with unique-violations very fast
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: requested shared memory size overflows size_t