On 4/27/15, Jim Nasby <jim.na...@bluetreble.com> wrote: > 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.
Good point. I noted that on the TOAST wiki page now, at least (and also mentioned that using partitioning is a "work around" for now). -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
