Re: Eh?

On Mon, 13 Aug 2001, Josh Berkus wrote:

> > > SHould I be concerned about this?
> >
> > > DEBUG:  geqo_main: using edge recombination crossover [ERX]
> >
> > Nope.  See
> > http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/geqo.html
>
> Cool!  I love it when I actually get the chance to see some advance
> theory applied.  And congrats on implementing it!

Yeah, this is really excellent.

> Of course, we'll see if it really boosts query optimization when there's
> a full data population.  This view has 3 UNION statements, 11
> subselects, 35 JOINS, and calls on 3 custom formatting functions ...

This makes me wonder... in the case of a stored complex view, would it be
helpful to ask PostgreSQL to spend extra time in query optimisation and
then cache the result?  Or does it do this already?
-- 
Tod McQuillin