Re: [BUGS] BUG #5608: array_agg() consumes too much memory - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUGS] BUG #5608: array_agg() consumes too much memory
Date
Msg-id 7547.1281792649@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] BUG #5608: array_agg() consumes too much memory  (Hitoshi Harada <umi.tanuki@gmail.com>)
List pgsql-hackers
Hitoshi Harada <umi.tanuki@gmail.com> writes:
> 2010/8/14 Itagaki Takahiro <itagaki.takahiro@gmail.com>:
>> 2010/8/10 Tom Lane <tgl@sss.pgh.pa.us>:
>>> Eventually it might be nice to have some sort of way to specify the
>>> estimate to use for any aggregate function --- but for a near-term
>>> fix maybe we should just hard-wire a special case for array_agg in
>>> count_agg_clauses_walker().

> So, is it better to generalize as it adds ALLOCSET_DEFAULT_INITSIZE if
> the transtype is internal, rather than specifying individual function
> OID as the patch stands?

Seems like a good idea ... it's ugly, but it seems much less likely to
need maintenance.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Recognize functional dependency on primary keys.
Next
From: Bruce Momjian
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Recognize functional dependency on primary keys.