Re: pg_class.relpages/allvisible probably shouldn't be a int4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_class.relpages/allvisible probably shouldn't be a int4
Date
Msg-id 17497.1399893060@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_class.relpages/allvisible probably shouldn't be a int4  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-05-12 10:07:29 +0300, Heikki Linnakangas 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.

Well, yeah, but that's on the to-do list in any case.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: cannot to compile PL/V8 on Fedora 20
Next
From: Fujii Masao
Date:
Subject: Re: Archive recovery won't be completed on some situation.