From: Konstantinos Krikellas <K.Krikellas@sms.ed.ac.uk>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org, Stratis Viglas <sviglas@inf.ed.ac.uk>
Subject: Re: Problem with joining queries.
Date: Thu, 15 Feb 2007 14:28:27 +0000
Message-ID: <1171549707.31678.29.camel@kkrik-desktop> (raw)
In-Reply-To: <45D467C6.5090501@archonet.com>
References: <1171544313.31678.22.camel@kkrik-desktop>
<45D467C6.5090501@archonet.com>
> 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@sms.ed.ac.uk
Pnone number: +44 (0) 131 651 3769
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: K.Krikellas@sms.ed.ac.uk, dev@archonet.com, sviglas@inf.ed.ac.uk
Subject: Re: Problem with joining queries.
In-Reply-To: <1171549707.31678.29.camel@kkrik-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox