Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7E4ocP33771 for ; Tue, 14 Aug 2001 00:50:38 -0400 (EDT) (envelope-from josh@agliodbs.com) Received: from [209.10.40.250] (account ) by davinci.ethosmedia.com (CommuniGate Pro WebUser 3.4.1) with HTTP id 101709; Mon, 13 Aug 2001 21:50:36 -0700 From: "Josh Berkus" Subject: Re: Eh? To: Tom Lane , "Josh Berkus" Cc: pgsql-sql@postgresql.org X-Mailer: CommuniGate Pro Web Mailer v.3.4.1 Date: Mon, 13 Aug 2001 21:50:36 -0700 Message-ID: In-Reply-To: <14484.997754522@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="_===101709====davinci.ethosmedia.com===_" X-Archive-Number: 200108/173 X-Sequence-Number: 4395 This is a multi-part MIME message --_===101709====davinci.ethosmedia.com===_ Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit 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 --_===101709====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===101709====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===101709====davinci.ethosmedia.com===_ Content-Type: text/plain Content-Disposition: attachment; filename="" Content-Transfer-Encoding: base64 DQo= --_===101709====davinci.ethosmedia.com===_--