Gerhard Hintermayer <gerhard.hintermayer@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
