Re: Parallel Aggregate

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Parallel Aggregate
Дата
Msg-id
CA+TgmobuOcw8xNvc6K-x5doiOk7xy0S6fW+jW8ketVTX6SMwgQ@mail.gmail.com
Ответ на
Re: Parallel Aggregate (David Rowley)
Список
Дерево обсуждения
Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Paul Ramsey <pramsey@cleverelephant.ca>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Paul Ramsey <pramsey@cleverelephant.ca>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Amit Langote <amitlangote09@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Paul Ramsey <pramsey@cleverelephant.ca>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate Robert Haas <robertmhaas@gmail.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate James Sewell <james.sewell@lisasoft.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Tom Lane <tgl@sss.pgh.pa.us>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Parallel Aggregate Simon Riggs <simon@2ndQuadrant.com>
Re: Parallel Aggregate David Rowley <david.rowley@2ndquadrant.com>
Re: Parallel Aggregate Haribabu Kommi <kommi.haribabu@gmail.com>
On Tue, Mar 15, 2016 at 6:55 PM, David Rowley
 wrote:
> On 16 March 2016 at 11:00, Robert Haas  wrote:
>> I don't see why we would need to leave aggpartial out of the equals()
>> check.  I must be missing something.
>
> See fix_combine_agg_expr_mutator()
>
> This piece of code:
>
> /*
> * Aggrefs for partial aggregates are wrapped up in a PartialAggref,
> * we need to look into the PartialAggref to find the Aggref within.
> */
> foreach(lc, context->subplan_itlist->tlist)
> {
> PartialAggref *paggref;
> tle = (TargetEntry *) lfirst(lc);
> paggref = (PartialAggref *) tle->expr;
>
> if (IsA(paggref, PartialAggref) &&
> equal(paggref->aggref, aggref))
> break;
> }
>
> if equals() compared the aggpartial then this code would fail to find
> the Aggref in the subnode due to the aggpartial field being true on
> one and false on the other Aggref.

...and why would one be true and the other false?

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


В списке pgsql-hackers по дате отправления
От: Andreas Karlsson
Дата:
Сообщение: Re: NOT LIKE index support
От: David Rowley
Дата:
Сообщение: Re: Parallel Aggregate
FAQ