Re: Eh?

Tom,

> > 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!

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 (two of
them many times).  A good "destruction test" for the GEQO, hey?  The
only thing I'm missing is a couple of LEFT OUTER JOINS and maybe a WHERE
NOT EXISTS.

-Josh

P.S. The purpose of the view is to "flatten" a large chunk of complex
relational data into a comma-delimited text table to be imported into an
accounting program.

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco