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