> > For instance: > > SELECT station, air_temp FROM obs > > WHERE station = 'EGBB' > > AND valid_time > '28/8/03 00:00' > > AND valid_time < '28/10/03 00:00' > > > > takes 4 mins 32 secs.
How many rows should that return? [explain analyze will tell you that] and while that runs is your disk thrashing? vmstat's bi/bo columns will tell you. 7.1 is quite old, but I do understand the pain of migraing to 7.3 [or .4beta] with huge db's -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
