Re: Maximum table size - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Maximum table size
Date
Msg-id 26098.1063087483@sss.pgh.pa.us
Whole thread Raw
In response to Maximum table size  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Maximum table size  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Maximum table size  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Maximum table size  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Is our maximum table size limited by the maximum block number?

Certainly.

> Is the 16TB number a hold-over from when we weren't sure block number
> was unsigned, though now we are pretty sure it is handled as unsigned
> consistenly?

It's a holdover.  As to how certain we are that all the
signed-vs-unsigned bugs are fixed, who have you heard from running a
greater-than-16Tb table?  And how often have they done CLUSTER, REINDEX,
or even VACUUM FULL on it?  AFAIK we have zero field experience to
justify promising that it works.

We can surely fix any such bugs that get reported, but we haven't got
any infrastructure that would find or prevent 'em.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Maximum table size
Next
From: Czuczy Gergely
Date:
Subject: Re: pgsql in shared lib