| From: | Peter T Mount <peter(at)retep(dot)org(dot)uk> |
|---|---|
| To: | Matthew Hagerty <matthew(at)venux(dot)net> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: [INTERFACES] Dealing with large query results |
| Date: | 1999-02-08 20:43:34 |
| Message-ID: | Pine.LNX.4.04.9902082039540.19320-100000@maidast.retep.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)retep(dot)org(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 1999-02-08 21:19:03 | Re: [INTERFACES] Rapid web based apps? |
| Previous Message | Matthew Hagerty | 1999-02-08 20:19:00 | Rapid web based apps? |