Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]
Дата
Msg-id 20070604131941.GJ32320@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]  (Ron St-Pierre <ron.pgsql@shaw.ca>)
Ответы Re: [Fwd: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum]  (Ron St-Pierre <ron.pgsql@shaw.ca>)
Список pgsql-general
On Fri, Jun 01, 2007 at 01:27:14PM -0700, Ron St-Pierre wrote:
>  imp=# select age(datfrozenxid) from pg_database where datname = 'imp';
>      age
>  ------------
>   1571381411
>  (1 row)
>
> Time to start VACUUM FULL ANALYZE over the weekend.

I guess this comes too late, but you don't need VACUUM FULL for that.
VACUUM FULL _does not_ mean "vacuum everything"!

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
        --Scott Morris

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

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: Tablespaces
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: High-availability