On 4/27/15, Jim Nasby <Jim.Nasby@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).
