Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id D400C632520;
	Wed, 21 Jan 2009 11:14:02 -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 79076-02-2; Wed, 21 Jan 2009 11:13:59 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from is.rice.edu (is.rice.edu [128.42.42.24])
	by mail.postgresql.org (Postfix) with ESMTP id D4FAD632525;
	Wed, 21 Jan 2009 11:13:59 -0400 (AST)
Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	by is.rice.edu (Postfix) with ESMTP id 70E6541820;
	Wed, 21 Jan 2009 09:13:57 -0600 (CST)
Received: from is.rice.edu ([128.42.42.24])
	by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160])
	(amavisd-new, port 10024)
	with ESMTP id 13278-04; Wed, 21 Jan 2009 09:13:56 -0600 (CST)
Received: by is.rice.edu (Postfix, from userid 18612)
	id AFF6241819; Wed, 21 Jan 2009 09:13:56 -0600 (CST)
Date: Wed, 21 Jan 2009 09:13:56 -0600
From: Kenneth Marshall <ktm@rice.edu>
To: Grzegorz Ja??kiewicz <gryzman@gmail.com>
Cc: paulo matadr <saddoness@yahoo.com.br>, pgsql-general@postgresql.org,
	admin <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] bytea size limit?
Message-ID: <20090121151356.GB28522@it.is.rice.edu>
References: <359812.4771.qm@web52512.mail.re2.yahoo.com>
	<2f4958ff0901210555y8b02b8dpa9db2b15873bf23a@mail.gmail.com>
	<20090121140623.GG14570@it.is.rice.edu>
	<901365.77018.qm@web52506.mail.re2.yahoo.com>
	<2f4958ff0901210707v5e639b39of59f678a19981c30@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <2f4958ff0901210707v5e639b39of59f678a19981c30@mail.gmail.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu
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/89
X-Sequence-Number: 31136

On Wed, Jan 21, 2009 at 03:07:13PM +0000, Grzegorz Ja??kiewicz wrote:
> On Wed, Jan 21, 2009 at 3:02 PM, paulo matadr <saddoness@yahoo.com.br> wrote:
> > My system have very large ram size, so its possible review postgresql.conf ?
> >
> all depends on how you access DB, what type of drivers (odbc, libpq, etc, etc).
> See, every time you pass a row , they usually have to allocate that
> much memory, not only its quite inefficient, but also slow.
> 
> As for the configuration option, I am interested in knowing myself too :)
> 
I do not think that the size limit is a runtime option. It is currently
compiled into the server.

Ken