Postgres Pro
Downloads
Home   >   mailing lists

Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT) - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT)
Date
Msg-id 29675.944181689@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT)  (Douglas Thomson <dougt@mugc.cc.monash.edu.au>)
Responses Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT)  (Douglas Thomson <dougt@mugc.cc.monash.edu.au>)
List pgsql-interfaces
Tree view 
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

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

pgsql-interfaces by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [INTERFACES] Slow join query optimisation?
Next
From: Douglas Thomson
Date:
Subject: Re: [INTERFACES] Back end memory consumption (was Front end memory consumption in SELECT)