Re: [HACKERS] Relpartbound, toasting and pg_class - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Relpartbound, toasting and pg_class
Date
Msg-id a0a0cc39-644b-9e0a-dd1a-f5fdefad8f06@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Relpartbound, toasting and pg_class  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Relpartbound, toasting and pg_class
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade
Next
From: Ants Aasma
Date:
Subject: Re: [HACKERS] WIP: Data at rest encryption