Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT)

Douglas Thomson <dougt@mugc.cc.monash.edu.au> writes:
> I have just noticed that the back end process swells to
> the total size of all the tables involved in my query for the
> duration of the SELECT (or is it the duration of the declared cursor
> now?).

The life of the cursor, probably, but I'm a little surprised by this.

> To summarise the situation:
>     - I am attempting a join on 9 tables, using a cursor to fetch the
>       selected data
>     - the back end process grows to over 20M while processing my query

What query plan does EXPLAIN show for your SELECT?
        regards, tom lane

************