Re: vacuum full...

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: vacuum full...
Дата
Msg-id dcc563d10902191211g73932526l468d9b8bd1c356ad@mail.gmail.com
обсуждение исходный текст
Ответ на Re: vacuum full...  (Rafael Domiciano <rafael.domiciano@gmail.com>)
Ответы Re: vacuum full...
Список pgsql-admin
On Thu, Feb 19, 2009 at 11:01 AM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> I used to run vacuum full in one of my bases, but now i'm not running
> anymore vacuum full, just vacuum analyze in the past 1 month, but the number
> of necessary pages is increasing every day, now it's in 311264... there is
> any problem this get increasing?
> When I runned Reindex few days ago, this number get not decreased.
> I now that vacuum full reorders the relation, but it's the only thing that
> it does?

Same question I had for the other poster, why are you not running
autovacuum?  Has it proven itself not up to the task?

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

Предыдущее
От: Rafael Domiciano
Дата:
Сообщение: Re: vacuum full...
Следующее
От: "Leticia Larrosa"
Дата:
Сообщение: configuration related to statistics