Re: RangeType internal use

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: RangeType internal use
Date: 2015-02-13 21:27:02
Message-ID: CANPAkgsm3bBZjoDSKokG2PJgpHtyY3PF7pkr+uiFO+V=o-b=rA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 13, 2015 at 3:13 PM, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)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.


In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2015-02-13 21:34:28 Re: RangeType internal use
Previous Message Andrew Dunstan 2015-02-13 21:24:48 Re: pg_regress writes into source tree