Gerhard Hintermayer <gerhard(dot)hintermayer(at)gmail(dot)com> 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