Re: ffunc called multiple for same value - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ffunc called multiple for same value
Date
Msg-id 28033.1090616483@sss.pgh.pa.us
Whole thread Raw
In response to Re: ffunc called multiple for same value  (Ian Burrell <imb@rentrak.com>)
List 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


pgsql-hackers by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: psql listTables
Next
From: Tom Lane
Date:
Subject: Re: psql listTables