I've not found an equivalent of the about PostgreSQL page that covers the limitations of the large object facility in particular, but reading between the lines I think the following is true:
- No more than 32TB of large objects can be stored (reason: they are all stored in a single table named
pg_largeobject, and the per-table size limit is 32TB (assuming default page size)).
- No more than 2^32 large objects can be stored (reason: the primary key of
oidwhich is a 32-bit quantity).
pg_largeobjectcannot be partitioned (reason: because it's a system catalog?)
Is this all correct?