Re: [HACKERS] libpq: why we need to fetch all rows?

>
> What could be done (and this is similar to what PROGRESS database does..I
> think)...
> You could request a select on a very large table. The server will NOT
> load all tuples that match the select, but only the Oid's of these tuples.
> When you are ready to read data, you do fetch, at which time the oid is
> used to get an entire tuple. So neither the server nor the client ever
> keep in memory more than one tuple at a time. This might not even be too
> hard to implement..A list of Oid could be a double-linked list withch
> would make it easy to traverse it back and forth with NEXT/ PREV and other
> statements. A lookup table of portals/cursors and their corresponding Oid
> tables could be maintained by the server.

The problem is that most results are joins, and there are multiple oid's
to deal with .

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------