Maximum table size

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Maximum table size
Дата
Msg-id 200309090445.h894jKg25151@candle.pha.pa.us
обсуждение исходный текст
Ответы Re: Maximum table size  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: row level lock and table level locks
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Maximum table size