Since PostgreSQL doesn't use cursors, you will have to avoid any queries that return all the keys.

PostgreSQL does use cursors and so can perl: Re^4: iteration through tied hash eat my memory. Don't misinform.