Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database?

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Is a limitation for the number of large objects that can be stored in a PostgreSQL database?
Дата
Msg-id m3llziezts.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Is a limitation for the number of large objects that can be stored in a PostgreSQL database?  (u15074 <u15074@hs-harz.de>)
Список pgsql-general
u15074 <u15074@hs-harz.de> writes:

> I want to store a lot of binary data (but not so big) as large
> objects in a PostgreSQl database.  Since the large objects are
> referenced by an identifier of type oid, which is of type unsigned
> int (right?), my question is, if the number of large objects that
> can be stored in the database is limited by the range of the oid?

Well, yes.  But that's more than 4 billion objects--you're much more
likely to run out of disk space before you run out of OIDs.

-Doug

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Catching errors in pl/pgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Redefining LIKE operator