Re: query : max size Bytea - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: query : max size Bytea
Date
Msg-id b42b73150712200953j799ae88am5b0d9648fcab1af6@mail.gmail.com
Whole thread Raw
In response to Re: query : max size Bytea  (Andrew Chernow <ac@esilo.com>)
List pgsql-hackers
On Dec 20, 2007 12:47 PM, Andrew Chernow <ac@esilo.com> wrote:
> Arunachalam Parthasarathy wrote:
> bytea uses up to 4 bytes to represent the binary string length (signed
> 32-bit integer).  So the max data size is 2G.

max data size is 2g, but only large objects can hit that...1gb limit
comes from toast and applies to pretty much anything else
(http://www.postgresql.org/docs/8.3/static/storage-toast.html).

merlin


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: query : max size Bytea
Next
From: Andrew Chernow
Date:
Subject: Re: query : max size Bytea