From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: jonesbl@WellsFargo.COM
Cc: pgsql-sql@postgresql.org
Subject: Re: FW: query problem "server sent binary data ... without
Date: Thu, 26 Sep 2002 23:15:33 -0400
Message-ID: <20425.1033096533@sss.pgh.pa.us> (raw)
In-Reply-To: <20020926160003.H30444-100000@megazone23.bigpanda.com>
References: <20020926160003.H30444-100000@megazone23.bigpanda.com>
Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> On Thu, 26 Sep 2002 jonesbl@WellsFargo.COM wrote:
>> the query runs for 10 minutes or so, then outputs:
> How much data is that sending? The client library is going to try to
> buffer the entire result set.
And, in fact, this is the typical behavior when it runs out of memory
for the result set :-( ... it loses track of the fact that it was
receiving a result set at all, and starts spitting out complaints
that it's not in the right state as it receives subsequent rows.
(That should be fixed someday, but no one's got round to it.)
Consider using a cursor so you can FETCH a reasonable number of rows
at a time.
regards, tom lane
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, sszabo@megazone23.bigpanda.com, jonesbl@WellsFargo.COM
Subject: Re: FW: query problem "server sent binary data ... without
In-Reply-To: <20425.1033096533@sss.pgh.pa.us>
* 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