Maximum table size - Mailing list pgsql-hackers

From Bruce Momjian
Subject Maximum table size
Date
Msg-id 200309090445.h894jKg25151@candle.pha.pa.us
Whole thread Raw
Responses Re: Maximum table size  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is our maximum table size limited by the maximum block number?

With our block number maximum of:
#define MaxBlockNumber                  ((BlockNumber) 0xFFFFFFFE)
0xFFFFFFFE = 4294967294

would the max table size really be (4GB * 8k) or 32 TB, not 16TB, as
listed in the FAQ:4.5) What is the maximum size for a row, a table, and a database?...    Maximum size for a table?
          16 TB
 

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?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: row level lock and table level locks
Next
From: Tom Lane
Date:
Subject: Re: Maximum table size