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 20100814154730.A811C7541D7@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.

Tags:
----
REL8_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        clauses.c (r1.277.2.2 -> r1.277.2.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c?r1=1.277.2.2&r2=1.277.2.3)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix planner to make a reasonable assumption about the amount of
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Further dtrace adjustments for the backend-IDs-in-relpath patch.