Re: Trigger more frequent autovacuums of heavy insert tables

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: Trigger more frequent autovacuums of heavy insert tables
Дата
Msg-id CAKAnmmLhP3TkNkZbX+BJ-tj8x59pTjk42Vf=MLrX9DtEP4u1Lw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Trigger more frequent autovacuums of heavy insert tables  (Melanie Plageman <melanieplageman@gmail.com>)
Ответы Re: Trigger more frequent autovacuums of heavy insert tables
Список pgsql-hackers
On Tue, Feb 25, 2025 at 11:03 AM Melanie Plageman <melanieplageman@gmail.com> wrote:
Because users can now manually update these values in pg_class, there wouldn't be a way to detect the difference
between a bogus relallfrozen value due to VM corruption or a bogus value due to manual statistics intervention.

Er..you had me until this. If manual monkeying of the system catalogs leads to a "bogus" error that resembles a real one, then sow the wind, and reap the whirlwind. I don't think that should be a consideration here.

--
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

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