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