Disable result buffering to frontend clients

From: Konstantinos Krikellas <K(dot)Krikellas(at)sms(dot)ed(dot)ac(dot)uk>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Disable result buffering to frontend clients
Date: 2007-02-22 11:02:50
Message-ID: 1172142170.4718.13.camel@kkrik-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2007-02-22 11:12:11 Re: Disable result buffering to frontend clients
Previous Message D'Arcy J.M. Cain 2007-02-21 22:04:06 Re: How to avoid vacuuming a huge logging table