Re: Trigger more frequent autovacuums of heavy insert tables
От | Nathan Bossart |
---|---|
Тема | Re: Trigger more frequent autovacuums of heavy insert tables |
Дата | |
Msg-id | Z74igqjAf5H58Hl_@nathan обсуждение исходный текст |
Ответ на | Re: Trigger more frequent autovacuums of heavy insert tables (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: Trigger more frequent autovacuums of heavy insert tables
|
Список | pgsql-hackers |
On Tue, Feb 25, 2025 at 01:52:28PM -0500, Robert Haas wrote: > Given that users could manually update the catalog, we have to be able > to tolerate bad data in the catalogs without the world ending. If that > code has to exist anyway, then it's not mandatory to cap. On the other > hand, there's no great virtue in refusing to correct data that we know > to be wrong. Unless there is some other consideration which makes one > way better than the other, this feels like author's choice. Maybe the most conservative choice is to simply follow the example of surrounding code. If it's careful to cap relallvisible to relpages, also have it cap relallfrozen. If not, don't. *shrug* In any case, I don't want to hold up this patch on this relatively minor point. This seems like something we could pretty easily change in the future if needed. -- nathan
В списке pgsql-hackers по дате отправления: