Re: slow query performance

Stephan Szabo wrote:
> But, back to the question, what is the definition of the index it's using?
> If you don't have already have an index on (station,valid_time does
> making one help?

From my original post:

           Index "obs_pkey"
 Attribute  |           Type
------------+--------------------------
 valid_time | timestamp with time zone
 station    | character(10)
unique btree

    Index "obs_station"
 Attribute |     Type
-----------+---------------
 station   | character(10)
btree

        Index "obs_valid_time"
 Attribute  |           Type
------------+--------------------------
 valid_time | timestamp with time zone
btree

(I suspect the obs_valid_time index is redundant, because of the obs_pkey
index - is that right?)

Cheers,
Dave.