Re: index usage on timestamp without time zone

Gerhard Hintermayer  wrote:
 
> Is there a way to make postgres use the index on the timestamp
> column ? The timing is from a test table, production tables have a
> lot more rows.
 
It's a mistake to assume that the plan you get on a small table will
resemble the plan you will get on a big table.  If you want to know
what the plan will be on the big table, at least run an EXPLAIN of
the query on that big table.
 
-Kevin