Re: When do vacuumed pages/tuples become available for reuse?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: When do vacuumed pages/tuples become available for reuse?
Дата
Msg-id 20190411150423.GA7441@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Ответы Re: When do vacuumed pages/tuples become available for reuse?  (rihad <rihad@mail.ru>)
Список pgsql-general
On 2019-Apr-11, rihad wrote:

> On 04/11/2019 06:41 PM, Alvaro Herrera wrote:
>
> > Perhaps it'd be better to vacuum this table much more often.
> > 
> Each run took 5-6 hours, now it takes 2-3 hours after I've tweaked some
> cost-based vacuum knobs.

But how often does it run?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: rihad
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?
Следующее
От: rihad
Дата:
Сообщение: Re: When do vacuumed pages/tuples become available for reuse?