Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id AAB3E6323BE;
	Wed, 21 Jan 2009 10:12:40 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 09515-01; Wed, 21 Jan 2009 10:12:36 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-bw0-f13.google.com (mail-bw0-f13.google.com
	[209.85.218.13])
	by mail.postgresql.org (Postfix) with ESMTP id F0B5F632335;
	Wed, 21 Jan 2009 10:12:35 -0400 (AST)
Received: by bwz6 with SMTP id 6so619015bwz.19
	for <multiple recipients>; Wed, 21 Jan 2009 06:12:34 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:message-id:subject:from:to:cc:content-type
	:content-transfer-encoding;
	bh=3tjWaY83VFKxESVP1MVxPaemqqeTIj0YErQaNxKqhQU=;
	b=aSnlAWbyZwfpHzlIgDyjY45bM3hHv11Bju4MrxXYzP/Wp0V8IByjrpa/6V2Y1q9fdd
	aTL+za54z6QjVbNnciY/9bNoLbFF/F2n+exj9X7Ciz8lAH2NqBKZM2Q8IIuPAbaHMdEV
	Zx/Ft/ZQ6pH6iqOaA5o+92DNbEl0W98LGvMZo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type:content-transfer-encoding;
	b=uZr/lX8Csa2cmdwLZk9e+Dk32Tz/RasXMNFbYpQ558OW4PbIUt7nT6UP2fk5H/gzGK
	2Z3N5ZpkpGHndF9JFg0auJkhxSySNnRBJj91tAl+xdnpVh6nFQj2dpNvKAUGsadIBvpA
	C0oaLEzw/lrjMQGwupc+ELSmGdCCABpMX+hds=
MIME-Version: 1.0
Received: by 10.180.213.15 with SMTP id l15mr2905063bkg.115.1232546941469;
	Wed, 21 Jan 2009 06:09:01 -0800 (PST)
In-Reply-To: <20090121140623.GG14570@it.is.rice.edu>
References: <359812.4771.qm@web52512.mail.re2.yahoo.com>
	<2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com>
	<20090121140623.GG14570@it.is.rice.edu>
Date: Wed, 21 Jan 2009 14:09:01 +0000
Message-ID: <2f4958ff0901210609j7ead1ca6k7b170f3e2be21448@mail.gmail.com>
Subject: Re: [GENERAL] bytea size limit?
From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com>
To: Kenneth Marshall <ktm@rice.edu>
Cc: paulo matadr <saddoness@yahoo.com.br>, pgsql-general@postgresql.org,
	admin <pgsql-admin@postgresql.org>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200901/80
X-Sequence-Number: 31127

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