From: Kenneth Marshall <ktm@rice.edu>
To: Grzegorz Ja??kiewicz <gryzman@gmail.com>
Cc: paulo matadr <saddoness@yahoo.com.br>
Cc: pgsql-general@postgresql.org, admin <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] bytea size limit?
Date: Wed, 21 Jan 2009 08:06:23 -0600
Message-ID: <20090121140623.GG14570@it.is.rice.edu> (raw)
In-Reply-To: <2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com>
References: <359812.4771.qm@web52512.mail.re2.yahoo.com>
<2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com>
On Wed, Jan 21, 2009 at 01:55:28PM +0000, Grzegorz Ja??kiewicz wrote:
> there's no real limit (its size is described with 32bit number, and
> that's the only limitation here).
> But you need to be aware, that content is sent over at once, so memory
> is the limit in your case.
>
> http://www.postgresql.org/docs/8.3/static/datatype-binary.html
>
> For such large objects, it might be actually better to store them
> separate as files, and just store file name.
>
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.
Cheers,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ktm@rice.edu, gryzman@gmail.com, saddoness@yahoo.com.br
Subject: Re: [GENERAL] bytea size limit?
In-Reply-To: <20090121140623.GG14570@it.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox