> > 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 <jeff@jefftrout.com>
http://www.jefftrout.com/http://www.stuarthamm.net/