Re: [SQL] timestamp query doesn't use an index ...

2006-05-21 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: - Bitmap Heap Scan on page_schedule ps2 (cost=573.65..2822.86 rows=91614 width=16) (actual time=149.788..505.438 rows=94798 loops=1) Recheck Cond: (timezone('MST7MDT'::text, start_time) = '2006-05-17 08:09:18'::timestamp without time

Re: [SQL] timestamp query doesn't use an index ...

2006-05-20 Thread Marc G. Fournier
On Sun, 21 May 2006, Michael Glaesemann wrote: 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