Scott Marlowe wrote:
Was this all the same basic task implemented by different teams then?
Yep.
Can we see the code? hack it? I'm sure someone here could help out.
Sure.
I don't care about the contest, but it would be nice to be able to put out a version that could compete with MySQL's.
Sure. The main db-contest site of the magazine is [1], but it's all german. You'lll find an english translation of the original article, describing the problem to solve in [2].
The contest entries are downloadable on [3]. Mine is the 'bluegap' one. If you want to hack together a high-performance solution based on PostgreSQL I'd start with Alvar C.H. Freude's disqualified entry.
Happy hacking Markus [1]: http://www.heise.de/ct/dbcontest/ [2]: http://firebird.sourceforge.net/connect/ct-dbContest.html [3]: http://www.heise.de/ct/dbcontest/teilnehmer.shtml ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match