Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group