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

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