From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
To: paulo matadr <saddoness@yahoo.com.br>
Cc: Kenneth Marshall <ktm@rice.edu>
Cc: pgsql-general@postgresql.org, admin <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] bytea size limit?
Date: Wed, 21 Jan 2009 15:07:13 +0000
Message-ID: <2f4958ff0901210707v5e639b39of59f678a19981c30@mail.gmail.com> (raw)
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>
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
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: gryzman@gmail.com, saddoness@yahoo.com.br, ktm@rice.edu
Subject: Re: [GENERAL] bytea size limit?
In-Reply-To: <2f4958ff0901210707v5e639b39of59f678a19981c30@mail.gmail.com>
* 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