Re: index usage on timestamp without time zone - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: index usage on timestamp without time zone
Date
Msg-id 4DB93C57020000250003CFEB@gw.wicourts.gov
Whole thread Raw
In response to index usage on timestamp without time zone  (Gerhard Hintermayer <gerhard.hintermayer@gmail.com>)
List pgsql-admin
Gerhard Hintermayer <gerhard.hintermayer@gmail.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

pgsql-admin by date:

Previous
From: Gerhard Hintermayer
Date:
Subject: index usage on timestamp without time zone
Next
From: Ron Peterson
Date:
Subject: pgcrypto pgp_pub_decrypt with passphrase broken