Hide Zen home
Use FETCH_COUNT internal psql variable to configure psql output
\set FETCH_COUNT 10
This will help to avoid memory problem, since psql waits until the complete result set has been produced, which can be very big.