Re: timestamp query doesn't use an index ...

On May 21, 2006, at 10:42 , Marc G. Fournier wrote:

>    ->  Seq Scan on page_schedule ps2  (cost=0.00..2364.95  
> rows=33110 width=16) (actual time=0.021..623.363 rows=94798 loops=1)

I don't know about rewriting the query, but it appears your  
statistics are a little out of date (e.g., rows expected/actual  
33110/94798). Does running ANALYZE help?


Michael Glaesemann
grzm seespotcode net