Re: Why does a simple query not use an obvious index?

Guy Thornley <guy@esphion.com> writes:

>             "stats__ends_at" btree (stats__ends_at("at", resolution, "values"))

Postgres 7.4 doesn't have any stats on functional indexes. So it's back to
just guessing at the selectivity of this. 8.0 does gather stats for functional
indexes so it should be better off.

--
greg