| From: | "Tim Barnard" <tbarnard(at)povn(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cursor question |
| Date: | 2001-05-25 16:55:14 |
| Message-ID: | 008a01c0e53b$78269700$a519af3f@hartcomm.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Disregard my last question. I've found I can use LIMIT
and OFFSET to control the number of records returned.
Tim
----- Original Message -----
From: Tim Barnard
To: pgsql-general(at)postgresql(dot)org
Sent: Friday, May 25, 2001 9:05 AM
Subject: [GENERAL] Cursor question
When retrieving the tuples from a select query using a cursor, are all of the matching tuples loaded into memory but only passed one at a time to the application using the cursor (I'm retrieving them with "fetch forward 1 in cursor" and using libpq)? Or is only each tuple loaded into memory, one at a time, with each fetch? I'm trying to figure out how much memory I'll need.
Tim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | feech | 2001-05-25 16:59:42 | Simple SQL question, need help. |
| Previous Message | Arcady Genkin | 2001-05-25 16:17:19 | Bitwise operators in SQL |