| 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:14 |
| Message-ID: | 20100814154714.13EB17541D7@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.
Modified Files:
--------------
pgsql/src/backend/optimizer/util:
clauses.c (r1.287 -> r1.288)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.287&r2=1.288)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-08-14 15:47:21 | pgsql: Fix planner to make a reasonable assumption about the amount of |
| Previous Message | Tom Lane | 2010-08-14 14:20:35 | pgsql: Fix \ef and \sf to not fail on functions with nonnull probin. |