Re: Any way to stop DBD::Pg from pre-fetching data?

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