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

From Tom Lane
Subject Re: [HACKERS] Relpartbound, toasting and pg_class
Date
Msg-id 11481.1497303813@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Relpartbound, toasting and pg_class  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Relpartbound, toasting and pg_class  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> 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?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Transactional sequence stuff breaks pg_upgrade
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] ICU support on Windows