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

Поиск
Список
Период
Сортировка
От rihad
Тема Re: When do vacuumed pages/tuples become available for reuse?
Дата
Msg-id c7d435c1-a6f6-d570-1698-b8791161d406@mail.ru
обсуждение исходный текст
Ответ на Re: When do vacuumed pages/tuples become available for reuse?  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: When do vacuumed pages/tuples become available for reuse?  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
On 04/11/2019 07:40 PM, Jeff Janes wrote:
On Thu, Apr 11, 2019 at 10:28 AM rihad <rihad@mail.ru> wrote:

Yup, it's just that n_dead_tuples grows by several hundred thousand (the
table sees much much more updates than inserts) and disk usage grows
constantly between several hour long vacuum runs. Running vacuum full
isn't an option.

The disk usage doesn't reach a steady state after one or two autovacs?  Or it does, but you are just unhappy about the ratio between the steady state size and the theoretical fully packed size?

Cheers,

Jeff


Since we dump&restore production DB daily into staging environment, the difference in size (as reported by psql's \l+) is 11GB in a freshly restored DB as opposed to 70GB in production.

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

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