Re: query : max size Bytea

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Andrew Chernow" <ac(at)esilo(dot)com>
Cc: "Arunachalam Parthasarathy" <arunachalamamsam(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: query : max size Bytea
Date: 2007-12-20 17:53:29
Message-ID: b42b73150712200953j799ae88am5b0d9648fcab1af6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Dec 20, 2007 12:47 PM, Andrew Chernow <ac(at)esilo(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Chernow 2007-12-20 17:54:05 Re: query : max size Bytea
Previous Message Andrew Chernow 2007-12-20 17:47:03 Re: query : max size Bytea