Re: autovacuum on updated rows

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum on updated rows
Дата
Msg-id 20051113190553.GH29473@surnet.cl
обсуждение исходный текст
Ответ на Re: autovacuum on updated rows  (Stephen Byers <stephenabyers@yahoo.com>)
Список pgsql-admin
Stephen Byers wrote:
> Sorry for noise.  It turns out that little pound sign in front bit me !!
> #autovacuum = on

So, does it work after you activate it?  Please note that there's a
threshold in the number of tuples that will need to be modified for
a vacuum operation to be launched.  For such a small table you may want
to lower the threshold a bit.  See the docs on the pg_autovacuum system
catalog, in the "internals" chapter.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: read only user
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: Re: Open connections details