Re: database 1.2G, pg_dump 73M?!

Поиск
Список
Период
Сортировка
От Anton Melser
Тема Re: database 1.2G, pg_dump 73M?!
Дата
Msg-id 92d3a4950804050843n5adcf45bh28d68f5296b9c53c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: database 1.2G, pg_dump 73M?!  (Ross Boylan <RossBoylan@stanfordalumni.org>)
Список pgsql-general
>  I am still trying to figure out if the database was getting any
>  automatic vacuuming at all.  The Postgres documentation (the database is
>  8.2, though I'm moving to 8.3 soon) sounds as if it's on automatically,
>  but the Debian-specific documentation suggests I may need to do some
>  additional things to enable it.

This is probably far too late but anyway. You do indeed have to enable
autovacuum with 8.2, as it isn't enabled by default, at least with
most distributions. 8.3 it's by default with most distributions.
# show autovacuum;
will tell you if it's on.
Cheers
Anton

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Conversion to 8.3
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: mac ports question