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 по дате отправления: