Re: Add TOAST support for more system tables

Поиск
Список
Период
Сортировка
От Sofia Kopikova
Тема Re: Add TOAST support for more system tables
Дата
Msg-id 5bc9737f-14d6-9c1b-ba93-907bbaada24d@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Add TOAST support for more system tables  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On Mon, Jul 17, 2023 at 06:31:04PM -0400, Tom Lane wrote:

> Sofia Kopikova <s.kopikova@postgrespro.ru> writes:
>> This patch adds TOAST support for system tables pg_class,
>> pg_attribute and pg_largeobject_metadata, as they include ACL columns,
>> which may be potentially large in size.
> We have been around on this topic before, cf discussion leading up to
> commit 96cdeae07.  Allowing toasted data in pg_class or pg_attribute
> seems quite scary to me because of the potential for recursive access,
> particularly during cache-flush scenarios.  (That is, you need to be
> able to read those catalogs on the way to fetching a toasted value,
> so how can you be sure that doesn't devolve into an infinite loop?)
Many thanks for your reviews. I'm gonna do research and revise this
feature thoroughly.

I'll set status of the patch to "Waiting on author" for now.

--
Sofia Kopikova
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company





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

Предыдущее
От: Nikita Malakhov
Дата:
Сообщение: Re: Protect extension' internal tables - how?
Следующее
От: mahendrakar s
Дата:
Сообщение: Re: Increase limit on max length of the password( pg versions < 14)