Tom Lane wrote:
> Andres Freund <> writes:
> > On 2017-06-12 17:10:28 -0400, Peter Eisentraut wrote:
> >> 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.
> > Because it's further increasing the size by something unbounded in size,
> > which'll not uncommonly be large? It makes a fair amount of sense to
> > partition by multiple columns at once (using the expression syntax).
> How about gathering some actual evidence on the point --- ie, how big
> a partition expression do you need to make it fall over?

You'd need a 2kB expression (after compression) in
relpartbound before you hit a problem here.  I wouldn't worry about it
at this stage ...

Not on point, but this conversation reminded me of
wherein you needed 2500 roles in an ACL column before it became a
problem -- and the project's stance is not to bother supporting that

Álvaro Herrera      
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to