Re: unexplained autovacuum to prevent wraparound

Поиск
Список
Период
Сортировка
От Gordon Shannon
Тема Re: unexplained autovacuum to prevent wraparound
Дата
Msg-id b2dd93301003121719k265a27f5p6030f098491b4ed3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: unexplained autovacuum to prevent wraparound  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Thanks, but I do want 1%.

On Fri, Mar 12, 2010 at 5:19 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On Fri, 2010-03-12 at 16:45 -0700, Gordon Shannon wrote:
> This is 8.4, there is no pg_autovacuum table.  I set it like this:
>
> alter table foo set (autovacuum_analyze_scale_factor=0.01);

That is 1% changes. I think you want .10

Sincerely,

Joshua D. Drake


>


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
Respect is earned, not gained through arbitrary and repetitive use or Mr. or Sir.




--
If I had more time, I could have written you a shorter letter.  (Blaise Pascal)

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

Предыдущее
От: "dario.ber@libero.it"
Дата:
Сообщение: Re: Function with DEFAULT arguments
Следующее
От: Harry Gold
Дата:
Сообщение: How to remove superuser