Re: Fwd: [GENERAL] 4B row limit for CLOB tables

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Дата
Msg-id 553DDC08.1020309@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (Roger Pack <rogerdpack2@gmail.com>)
Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (José Luis Tallón<jltallon@adv-solutions.net>)
Список pgsql-hackers
On 4/25/15 1:19 PM, Bruce Momjian wrote:
>     Note if you are storing a table with rows that exceed 2KB in size
>     (aggregate size of each row) then the "Maximum number of rows in a
>     table" may be limited to 4 Billion, see TOAST.

That's not accurate though; you could be limited to far less than 4B 
rows. If each row has 10 fields that toast, you'd be limited to just 
400M rows.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: collate.linux.utf8 test coverage
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Missing psql tab-completion for ALTER FOREIGN TABLE