Re: [INTERFACES] Dealing with large query results - Mailing list pgsql-interfaces

On Mon, 8 Feb 1999, Matthew Hagerty wrote:

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

No. The entire result is returned.

The 8k limit is the block size used to store data on disk. The limit
affects the size of each row, not the query results.

--
       Peter T Mount peter@retep.org.uk
      Main Homepage: http://www.retep.org.uk
PostgreSQL JDBC Faq: http://www.retep.org.uk/postgres
 Java PDF Generator: http://www.retep.org.uk/pdf