Ben Tilly wrote:
I know that there is a way in the Java driver to have it turn the prefetching off. I don't know how it is done though. That may be a recent improvement in PostgreSQL.
AFAIK libpq fetches all the data - DBD::Pg doesn't have a choice. The JDBC driver doesn't use libpq, of course.
And yes, using a cursor is the way to get around this. cheers andrew
