From: Matthew Hagerty <matthew@venux.net>
To: pgsql-interfaces@postgreSQL.org
Subject: Dealing with large query results
Date: Mon, 08 Feb 1999 15:06:55 -0500
Message-ID: <4.1.19990208145905.00a0b8d0@mail.venux.net> (raw)
Greetings,
I keep seeing reference to an 8K limit on query results. So how to deal
with query results greater than 8K? Am I under the wrong impression that
when you run a query from, say libpq, that each retch row is returned only
when you execute a fetchrow? Or is the whole query stuffed in to a buffer
which has an 8K limit?
I have to deal with some queries that create a huge result, and/or doing
reports requires a large result set. How can I deal with these larger results?
I'll probably get flamed for asking this one but, how can I step through a
table? Hey, sometimes you just have to do it.
Thanks,
Matthew
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-interfaces@postgresql.org
Cc: matthew@venux.net
Subject: Re: Dealing with large query results
In-Reply-To: <4.1.19990208145905.00a0b8d0@mail.venux.net>
* 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