Hi all,
according this page [1], large object are limited to the OID range of 2^32
(since it's a 4 bytes number).
I'm working on a use case were there are many tables with blobs (on
average not so large 32KB).
I foresee that in 2-3 years time frame, the limit of overall blobs will be
breached: more than 2^32 blobs.
- Is there a way to change the OID limit?
- Should we switch to a bytea implementation?
- Are there any drawback of bytea except the maximum space?
Thank you!
All the best,
Donato
[1]:
https://www.microolap.com/products/connectivity/postgresdac/help/tipsandtricks_byteavsoid.htm