Re: How to get more than 2^32 BLOBs

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: How to get more than 2^32 BLOBs
Дата
Msg-id 50a88c5152f9dee204f1c10a95dd90651585efcb.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: How to get more than 2^32 BLOBs  (Donato Marrazzo <donato.marrazzo@gmail.com>)
Ответы Re: How to get more than 2^32 BLOBs  (Donato Marrazzo <donato.marrazzo@gmail.com>)
Список pgsql-admin
On Wed, 2020-04-08 at 12:12 +0200, Donato Marrazzo wrote:
> 
> Il giorno mer 8 apr 2020 alle ore 12:06 Laurenz Albe <laurenz.albe@cybertec.at> ha scritto:
> > On Wed, 2020-04-08 at 11:15 +0200, Donato Marrazzo wrote:
> > > 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?
> > 
> > Don't use large objects.  They are only useful if
> > 1) you have files larger than 1GB or
> > 2) you need to stream writes
> > 
> > There are no such limitations if you use the "bytea" data type, and it is
> > much simpler to handle at the same time.
> 
> Are you aware of any performance drawback?

No; in fact, "bytea" performs better.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




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

Предыдущее
От: Christophe Courtois
Дата:
Сообщение: Re: How to get more than 2^32 BLOBs
Следующее
От: Donato Marrazzo
Дата:
Сообщение: Re: How to get more than 2^32 BLOBs