Re: pg_class.relpages/allvisible probably shouldn't be a int4

On 12 May 2014 08:15, Andres Freund <andres@2ndquadrant.com> wrote:

>> But I concur that in practice, if you're dealing with 16TB tables, it's time
>> to partition.
>
> Well, we need to improve our partitioning for that to be viable for all
> relations. Not having usable foreign and unique keys makes it a pita in
> some cases.

As discussed, declarative partitioning is on the roadmap for this next
release, so I would say lets just document that tablesizes above 16TB
don't report correctly and move on.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services