From: Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Disable result buffering to frontend clients
Date: Thu, 22 Feb 2007 11:02:50 +0000
Message-ID: <1172142170.4718.13.camel@kkrik-desktop> (raw)
Hi,
I am trying to execute some queries in PostgreSQL that produce a large
number of results and I do not want to display the output (redirect it
to /dev/null). I have tried the psql client with \o /dev/null option,
JDBC and libpq functions, but all of them have to buffer totally the
result before redirecting it. Is there any way to disable result
buffering, either on the client or on the server side? Note that the
EXPLAIN ANALYSE does not produce consistent estimations as it seems to
avoid calling the result tuple construction function. This is concluded
by the fact that augmenting the projection width hardly changes the
execution time, which is incompatible with the supplementary field copy
cost.
Thanks.
Konstantinos Krikellas
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-performance@postgresql.org
Cc: K.Krikellas@sms.ed.ac.uk
Subject: Re: Disable result buffering to frontend clients
In-Reply-To: <1172142170.4718.13.camel@kkrik-desktop>
* 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