Re: [PATCH] Add TOAST support for several system tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [PATCH] Add TOAST support for several system tables
Дата
Msg-id 2748770.1646089728@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [PATCH] Add TOAST support for several system tables  (Sofia Kopikova <s.kopikova@postgrespro.ru>)
Ответы Re: [PATCH] Add TOAST support for several system tables
Список pgsql-hackers
=?UTF-8?B?U29maWEgS29waWtvdmE=?= <s.kopikova@postgrespro.ru> writes:
> ACL lists in tables may potentially be large in size. I suggest adding TOAST support for system tables, namely
pg_class,pg_attribute and pg_largeobject_metadata, for they include ACL columns. 

TBH, the idea of adding a toast table to pg_class scares the daylights
out of me.  I do not for one minute believe that you've fixed every
problem that will cause, nor do I think "allow wider ACLs" is a
compelling enough reason to take the risk.

I wonder if it'd be practical to move the ACLs for relations
and attributes into some new table, indexed like pg_depend or
pg_description, so that we could dodge that whole problem.
pg_attrdef is a prototype for how this could work.

(Obviously, once we had such a table the ACLs for other things
could be put in it, but I'm not sure that the ensuing breakage
would be justified for other sorts of objects.)

            regards, tom lane



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: MSVC build system installs extra executables
Следующее
От: Tom Lane
Дата:
Сообщение: Overflow of attmissingval is not handled gracefully