Re: [HACKERS] Relpartbound, toasting and pg_class

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Relpartbound, toasting and pg_class
Дата
Msg-id a0a0cc39-644b-9e0a-dd1a-f5fdefad8f06@2ndquadrant.com
обсуждение исходный текст
Ответ на [HACKERS] Relpartbound, toasting and pg_class  (Andres Freund <andres@anarazel.de>)
Ответы Re: [HACKERS] Relpartbound, toasting and pg_class  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On 6/12/17 15:38, Andres Freund wrote:
> Just noticed that pg_class now has several varlena fields:
> #ifdef CATALOG_VARLEN            /* variable-length fields start here */
>     /* NOTE: These fields are not present in a relcache entry's rd_rel field. */
>     aclitem        relacl[1];        /* access permissions */
>     text        reloptions[1];    /* access-method-specific options */
>     pg_node_tree relpartbound;    /* partition bound node tree */
> #endif
> 
> of those relpartbound is fairly new. And pretty much unbounded in
> size. Aren't we going to run into issues because pg_class doesn't have a
> toast table? It's quite reasonable to use a multi-field composite type
> as a partition boundary...

Cases where relacl became too large have been known to exist.  I'm not
sure whether relpartbound can really be that large to change the
scenario significantly.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade
Следующее
От: Ants Aasma
Дата:
Сообщение: Re: [HACKERS] WIP: Data at rest encryption