How to get more than 2^32 BLOBs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux