Simon, > > Also, it would be a good time to suggest some way for making > > EXPLAIN script-friendly. Like return data as a computer program > > convenient table?
I'm already trying to kludge this in Perl. It would help automated testing considerably if explain analyze could be output as tab-delimited text instead of the human-readable version. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(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