Re: Relpartbound, toasting and pg_class

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