Not happening here (8.2.x, output redirected using "\o /dev/null") - are you sure it's not psql (or whatever client) that's using up your memory, as it tries to build the entire result set before sending it to /dev/null? Don't forget, you've got 5 copies of the columns so that would be ~ 700MB. If it is the backend, you'll need to give some of the tuning parameters you're using, since it works here on my much smaller dev server (1GB RAM and plenty of other stuff using it).
You are absolutely right about the result size.
I tried the '\o /dev/null' and worked, I had not realised the client is buffering the final result.
Instead, I used to execute the command 'psql < query.sql > /dev/null', so the psql process consumed all the available memory.
Thank you very much for your immediate and felicitous response.
Kind regards,
Konstantinos Krikellas PhD student, Database Group University of Edinburgh Email: K.Krikellas@xxxxxxxxxxxx Pnone number: +44 (0) 131 651 3769 |
