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.