Re: ffunc called multiple for same value

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Burrell <imb@rentrak.com>
Cc: pgsql-hackers@postgresql.org
Date: 2004-07-23T21:01:23Z
Lists: pgsql-hackers
Ian Burrell <imb@rentrak.com> writes:
> We are doing things in the aggregates that make them troublesome when 
> called the ffunc is called multiple times.  The state structure uses a 
> lot of memory for intermediate work.  The memory needs to be freed as 
> soon as possible otherwise there is a danger of running of out memory. 

Possibly you should just force enable_hashagg off, if you are concerned
about memory usage.  ISTM that running multiple transvalue calculations
in parallel is a bad idea from the start, if you are feeling that tense
about the amount of memory that will be chewed up by just one.

			regards, tom lane