Re: Fwd: [GENERAL] 4B row limit for CLOB tables - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Date
Msg-id 553DDC08.1020309@BlueTreble.com
Whole thread Raw
In response to Re: Fwd: [GENERAL] 4B row limit for CLOB tables  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Fwd: [GENERAL] 4B row limit for CLOB tables
Re: Fwd: [GENERAL] 4B row limit for CLOB tables
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: collate.linux.utf8 test coverage
Next
From: Etsuro Fujita
Date:
Subject: Missing psql tab-completion for ALTER FOREIGN TABLE