Re: slow query performance

> > 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/