> Thanks for the tip, I'll give this a shot soon. I am curious, your
> example above does not use GROUP BY yet you have an INDEX SCAN. I am
> using a similar query, yet I get a full table scan. I wonder how they
> are different?
Please send us the results of EXPLAIN ANALYZE the query. The EXPLAIN
results usually aren't too interesting for degenerate queries.
Also, make sure you have run ANALYZE on your database.
Chris