Re: Add TOAST support for more system tables - Mailing list pgsql-hackers

From Sofia Kopikova
Subject Re: Add TOAST support for more system tables
Date
Msg-id 5bc9737f-14d6-9c1b-ba93-907bbaada24d@postgrespro.ru
Whole thread Raw
In response to Re: Add TOAST support for more system tables  (Michael Paquier <michael@paquier.xyz>)
List 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 by date:

Previous
From: Nikita Malakhov
Date:
Subject: Re: Protect extension' internal tables - how?
Next
From: mahendrakar s
Date:
Subject: Re: Increase limit on max length of the password( pg versions < 14)