http://qs1969.pair.com?node_id=11127508


in reply to Posgres batch read with DBI?

cut down on db transaction overhead.

Depending on what you're up to, you can also set AutoCommit off, then count changed records while you process, and commit every N changes (every 1000 or so). It may be simpler.