Re: What is the max size for a bytea field? - Mailing list pgsql-general

From Joe Conway
Subject Re: What is the max size for a bytea field?
Date
Msg-id 3F12DCDD.5020402@joeconway.com
Whole thread Raw
In response to What is the max size for a bytea field?  (u15074 <u15074@hs-harz.de>)
List 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 by date:

Previous
From: u15074
Date:
Subject: What is the max size for a bytea field?
Next
From: "scott.marlowe"
Date:
Subject: Re: What is the max size for a bytea field?