RE: Large selects handled inefficiently?

Andrew Snow <als@fl.net.au>

From: "Andrew Snow" <als@fl.net.au>
To: "Pgsql-General@Postgresql. Org" <pgsql-general@postgresql.org>
Date: 2000-08-30T14:22:36Z
Lists: pgsql-general
> I believe I can work around this problem using cursors (although I
> don't know how well DBD::Pg copes with cursors).  However, that
> doesn't seem right -- cursors should be needed to fetch a large query
> without having it all in memory at once...

Actually, I think thats why cursors were invented in the first place ;-)  A
cursor is what you are using if you're not fetching all the results of a
query.


- Andrew