Re: Improving planner's handling of min/max aggregate optimization

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Improving planner's handling of min/max aggregate optimization
Date: 2010-11-03 18:03:18
Message-ID: AANLkTi=CnfyTnTTNhXJNGrKuV7fBs+7=S8jAmhjLFdu4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 1, 2010 at 8:16 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> This will make the min/max optimization code more visible to the rest of
> the planner in a couple of ways: aside from being called at two places
> not one, it will have some intermediate state that'll have to be kept in
> PlannerInfo, and the "useful pathkeys" logic will have to be complicit
> in letting paths that match the aggregates' requirements survive.  But
> it's not real bad, and it seems a lot better than continuing with the
> fully-at-arms-length approach.
>
> Comments?

+1.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2010-11-03 19:28:03 Re: max_wal_senders must die
Previous Message Alvaro Herrera 2010-11-03 17:15:39 Fwd: Re: ALTER OBJECT any_name SET SCHEMA name