Re: [HACKERS] [GENERAL] CLOB & BLOB limitations in PostgreSQL

2014-04-14 Thread Tom Lane
Bruce Momjian writes: > Uh, I had not thought of this before but I think we need oids for toast > storage, which would explain this wiki text: > https://wiki.postgresql.org/wiki/BinaryFilesInDB > Storing binary data using bytea or text data types > Minus >

Re: [HACKERS] [GENERAL] CLOB & BLOB limitations in PostgreSQL

2014-04-14 Thread David G Johnston
Bruce Momjian wrote > On Mon, Apr 14, 2014 at 02:01:19PM +0200, Ivan Voras wrote: >> On 11/04/2014 16:45, Jack.O' > Sullivan@ > wrote: >> >> > With point two, does this mean that any table with a bytea datatype is >> > limited to 4 billion rows (which would seem in conflict with the >> > "unlim

Re: [HACKERS] [GENERAL] CLOB & BLOB limitations in PostgreSQL

2014-04-14 Thread Bruce Momjian
On Mon, Apr 14, 2014 at 02:01:19PM +0200, Ivan Voras wrote: > On 11/04/2014 16:45, Jack.O'sulli...@tessella.com wrote: > > > With point two, does this mean that any table with a bytea datatype is > > limited to 4 billion rows (which would seem in conflict with the > > "unlimited rows" shown by htt