Re: [GENERAL] bytea size limit? - Mailing list pgsql-admin

From Grzegorz Jaśkiewicz
Subject Re: [GENERAL] bytea size limit?
Date
Msg-id 2f4958ff0901210609j7ead1ca6k7b170f3e2be21448@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] bytea size limit?  (Kenneth Marshall <ktm@rice.edu>)
Responses Re: [GENERAL] bytea size limit?  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-admin
On Wed, Jan 21, 2009 at 2:06 PM, Kenneth Marshall <ktm@rice.edu> wrote:

> The TOAST implementation however only allows 30-bits for the
> size of the TOAST entry which caps the size at 2^30 or 1GB. I
> agree that he could very well be limited also by the memory on
> his system.

i wasn't aware of that, and also - it doesn't say anything about it in docs.
As for limitations, that also depends on db drivers he is using, etc,
etc. I use bytea to store 100-200MB objects in many dbs, but I
wouldn't go as far as 1.5GB ...



--
GJ

pgsql-admin by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] bytea size limit?
Next
From: Kenneth Marshall
Date:
Subject: Re: [GENERAL] bytea size limit?