From: | tgl(at)postgresql(dot)org (Tom Lane) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Fix planner to make a reasonable assumption about the amount of |
Date: | 2010-08-14 15:47:21 |
Message-ID: | 20100814154721.C1C347541D7@cvs.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Log Message:
-----------
Fix planner to make a reasonable assumption about the amount of memory space
used by array_agg(), string_agg(), and similar aggregate functions that use
"internal" as their transition datatype. The previous coding thought this
took *no* extra space, since "internal" is pass-by-value; but actually these
aggregates typically consume a great deal of space. Per bug #5608 from
Itagaki Takahiro, and fix suggestion from Hitoshi Harada.
Back-patch to 8.4, where array_agg was introduced.
Tags:
----
REL9_0_STABLE
Modified Files:
--------------
pgsql/src/backend/optimizer/util:
clauses.c (r1.287 -> r1.287.4.1)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.287&r2=1.287.4.1)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-08-14 15:47:30 | pgsql: Fix planner to make a reasonable assumption about the amount of |
Previous Message | Tom Lane | 2010-08-14 15:47:14 | pgsql: Fix planner to make a reasonable assumption about the amount of |