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