Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id F34AB63255A;
	Wed, 21 Jan 2009 10:01:29 -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 95571-08; Wed, 21 Jan 2009 10:01:20 -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 706506323CA;
	Wed, 21 Jan 2009 09:59:57 -0400 (AST)
Received: by bwz6 with SMTP id 6so607001bwz.19
	for <multiple recipients>; Wed, 21 Jan 2009 05:59:55 -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=lFmvLCcvziR8PNdOzmKBTSA9wdUyqc5xBa0Bv/Tm6OM=;
	b=KEiUmLuv2arBgZ5dNGRSYSIO8pSaOYZBYbaSz0bgly2vZjnzxQ3gD2kmTX7y3HHVYL
	v0H81nXPijwcYDIazwJqXwQuKj6Oe4swQSvsuv2BmUJS8sK21tHB1VDV3LoQp9onbwfa
	+kSPCyCN30siHztEbJTQDt9CAtLQWiZui/t8w=
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=NG/a9Ok9Kii7jUVNWjVrljRCpo1NsnRcFVcWR/CBv8D+sFeg6yxHtxeXCuJV2mDgIh
	nDzKO7J6890bFboJaQgo5j6v2mFVTcQ9bp4EKKRck1BEEbRrJKSvSgftHh+V/PArPIyj
	ulSeqfCiq4tczQLryEJzR5f0M35pnuAKYahRI=
MIME-Version: 1.0
Received: by 10.181.226.2 with SMTP id d2mr2909901bkr.15.1232546128346; Wed,
	21 Jan 2009 05:55:28 -0800 (PST)
In-Reply-To: <359812.4771.qm@web52512.mail.re2.yahoo.com>
References: <359812.4771.qm@web52512.mail.re2.yahoo.com>
Date: Wed, 21 Jan 2009 13:55:28 +0000
Message-ID: <2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com>
Subject: Re: [GENERAL] bytea size limit?
From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= <gryzman@gmail.com>
To: paulo matadr <saddoness@yahoo.com.br>
Cc: 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/78
X-Sequence-Number: 31125

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.