Re: RangeType internal use - Mailing list pgsql-hackers

From Mike Blackwell
Subject Re: RangeType internal use
Date
Msg-id CANPAkgsm3bBZjoDSKokG2PJgpHtyY3PF7pkr+uiFO+V=o-b=rA@mail.gmail.com
Whole thread Raw
In response to Re: RangeType internal use  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers

On Fri, Feb 13, 2015 at 3:13 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:

If we exclude the issue of needing one or two oddball partitions for +/- infinity, I expect that fixed sized partitions would actually cover 80-90% of cases.

​That would not be true in our case.  The data is not at all evenly distributed over the partitioning key.  We would need something more like: values a, b, and c get their own partitions and everything else goes in partition d.

 

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pg_regress writes into source tree
Next
From: David Fetter
Date:
Subject: Re: RangeType internal use