Re: Should vacuum process config file reload more often

Поиск
Список
Период
Сортировка
От John Naylor
Тема Re: Should vacuum process config file reload more often
Дата
Msg-id CAFBsxsGLDxNus6=8LiQihrjvOrZuu7JdpC3ykDk2vzciTU6m+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Should vacuum process config file reload more often  (Jim Nasby <nasbyj@amazon.com>)
Ответы Re: Should vacuum process config file reload more often  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers

On Thu, Mar 9, 2023 at 12:42 AM Jim Nasby <nasbyj@amazon.com> wrote:
>
> Doesn't the dead tuple space grow as needed? Last I looked we don't allocate up to 1GB right off the bat.

Incorrect.

> Of course, if the patch that eliminates the 1GB vacuum limit gets committed the situation will be even worse.

If you're referring to the proposed tid store, I'd be interested in seeing a reproducible test case with a m_w_m over 1GB where it makes things worse than the current state of affairs.

--
John Naylor
EDB: http://www.enterprisedb.com

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Raising the SCRAM iteration count
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: Track IO times in pg_stat_io