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 [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
