Re: optimizer questions

--On Dienstag, Februar 14, 2006 10:35:12 -0600 hector Corrada Bravo
<hcorrada(at)gmail(dot)com> wrote:

> Before I start trying this (creating aggregate paths seems the
> reasonable thing to do) I would like your counsel.
>
> 1) Regardless of the optimization problem, is the executor able to
> execute aggregate nodes within join trees (that is, not as the result
> of subqueries)?
>
> 2) Has anyone tried something like this before?
I did and failed because I did not quite understand how the Postgres
internal variables should be initialized.

My approach was to supply other join pathes if one of the two tables was an
aggregate.

Mit freundlichem Gruß
Jens Schicke
--
Jens Schicke j(dot)schicke(at)asco(dot)de
asco GmbH http://www.asco.de
Mittelweg 7 Tel 0531/3906-127
38106 Braunschweig Fax 0531/3906-400