Re: slow query performance

Mark wrote:
> - interchanging the key order for the "obs_pkey" index and

I will try this.

> - clustering the "obs" table on "station"

Sorry, I don't understand what you mean by this - can you explain?


> create index obs_valid_time _stat1 on obs(valid_time) where station =
'station 1';
>

Interesting. I didn't know you could do that (I have a lot to learn!).
There are about 13500 stations, so that's a lot of indexes.

Hang on - just tried it and I get a 'parse error at or near "where"', so
I suspect that's yet another reason to upgrade...

I think the one message that's come across loud and clear from this
thread is "Upgrade!", so I guess that's what I'll be doing!

Many thanks to all who have contributed to this thread so far.
I really appreciate al hte help.

Cheers,
Dave.