>> On 1/29/15, Roger Pack <rogerdpa...@gmail.com> wrote: >>> Hello. I see on this page a mention of basically a 4B row limit for >>> tables that have BLOB's >> >> Oops I meant for BYTEA or TEXT columns, but it's possible the >> reasoning is the same... > > It only applies to large objects, not bytea or text.
OK I think I figured out possibly why the wiki says this. I guess BYTEA entries > 2KB will be autostored via TOAST, which uses an OID in its backend. So BYTEA has a same limitation. It appears that disabling TOAST is not an option [1]. So I guess if the number of BYTEA entries (in the sum all tables? partitioning doesn't help?) with size > 2KB is > 4 billion then there is actually no option there? If this occurred it might cause "all sorts of things to break"? [2] Thanks! -roger- [1] http://www.postgresql.org/message-id/20130405140348.gc4...@awork2.anarazel.de [2] http://www.postgresql.org/message-id/CAL1QdWfb-p5kE9DT2pMqBxohaKG=vxmdremsbjc+7tkboek...@mail.gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
