Re: What is the max size for a bytea field?

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: What is the max size for a bytea field?
Дата
Msg-id 3F12DCDD.5020402@joeconway.com
обсуждение исходный текст
Ответ на What is the max size for a bytea field?  (u15074 <u15074@hs-harz.de>)
Список pgsql-general
u15074 wrote:
> I'd like to know what the max size for a bytea field is.
> I can't find any according information in the docs.
>

I believe the theoretical max is 2 ^ 30 (1,073,741,824 bytes, i.e. about
1 GB). However keep in mind that you'll need several times that
memory-wise for the various copies of the field while processing it.

Joe



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

Предыдущее
От: u15074
Дата:
Сообщение: What is the max size for a bytea field?
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: What is the max size for a bytea field?