Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Fix planner to make a reasonable assumption about the amount of - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix planner to make a reasonable assumption about the amount of
Date
Msg-id 20100814154714.13EB17541D7@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix \ef and \sf to not fail on functions with nonnull probin.
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix planner to make a reasonable assumption about the amount of