Re: Problem with joining queries.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux