How to get more than 2^32 BLOBs

Поиск
Список
Период
Сортировка
От Donato Marrazzo
Тема How to get more than 2^32 BLOBs
Дата
Msg-id CAC1K4Ghi6fa0ck4rrB4MSaOLas9MY4mnF-jNF4iwiy75UVj4iQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get more than 2^32 BLOBs  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Toomas Kristin
Дата:
Сообщение: Re: Vault or AWS/IAM
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: How to get more than 2^32 BLOBs