On Mon, 2008-02-04 at 15:09 -0500, Greg Smith wrote: > On Mon, 4 Feb 2008, Simon Riggs wrote: > > > Would anybody like to repeat these tests with the latest production > > versions of these databases (i.e. with PGSQL 8.3) > > Do you have any suggestions on how people should run TPC-H? It looked > like a bit of work to sort through how to even start this exercise. The link referred to a few different scale factors, so you could try those. But anything that uses the hardware you have to its full potential is valuable. Everybody's test method is going to be different, whatever I say... -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(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
