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

From: Joe Conway <mail(at)joeconway(dot)com>
To: u15074 <u15074(at)hs-harz(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is the max size for a bytea field?
Date: 2003-07-14 16:39:57
Message-ID: 3F12DCDD.5020402@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-07-14 16:41:18 Re: What is the max size for a bytea field?
Previous Message u15074 2003-07-14 16:34:35 What is the max size for a bytea field?