Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 68F98632417;
	Wed, 21 Jan 2009 11:09:21 -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 70871-08; Wed, 21 Jan 2009 11:09:17 -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-f16.google.com (mail-bw0-f16.google.com
	[209.85.218.16])
	by mail.postgresql.org (Postfix) with ESMTP id B39486323BE;
	Wed, 21 Jan 2009 11:09:15 -0400 (AST)
Received: by bwz9 with SMTP id 9so880bwz.19
	for <multiple recipients>; Wed, 21 Jan 2009 07:09:13 -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=E5M4NFmquLIE1gUNMclpJtdMfYG7LVE+eQnjnOi1okk=;
	b=aNGgctnz3qugmASvGZvP1oYtllPGJ/RepYEYDvf/hKwZBO94dUly1fgnJrAPfT2IHO
	5SFCDYLx7fAEiTvhiDjSJKVBWRIRGEaAhcbajRnJImPgzNssqul8HEeTUKDxQSOeaQjF
	hBVsOe492skWmcDFi700pvuD9gnVh3jCpgqJg=
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=GtL4EFl27AuNap8nS02lt/gTTTuJRyID78GUAWjdVSB0STNuvKY4KsGmB6qhm72J2U
	T8davrrsR020XkI0poSO0sl0jJ2LGSFM0cDkxefredUfy78rrCxGx1dP3ZE3lUF4Ukej
	3RETWWoVeGRAfl6BB3PAENeLbnRV8ccR7pn0E=
MIME-Version: 1.0
Received: by 10.181.138.13 with SMTP id q13mr2925988bkn.95.1232550433359;
 Wed,
	21 Jan 2009 07:07:13 -0800 (PST)
In-Reply-To: <901365.77018.qm@web52506.mail.re2.yahoo.com>
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>
Date: Wed, 21 Jan 2009 15:07:13 +0000
Message-ID: <2f4958ff0901210707v5e639b39of59f678a19981c30@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: Kenneth Marshall <ktm@rice.edu>, 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/88
X-Sequence-Number: 31135

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 :)

-- 
GJ