Re: function based index problem

Viktor Bojovi*<viktor.bojovic@gmail.com> wrote:

> i don't know why it doesn't use index scan.

Because it thinks your query will return 81226 rows.  We need more
information to make many suggestions beyond "make sure the table has
been analyzed".

http://wiki.postgresql.org/wiki/SlowQueryQuestions

Also, it's not considered good form to post an issue to more than
one PostgreSQL list.  This is probably most appropriate on the
pgsql-performance list, so if you want to follow up with more detail
to get more detailed suggestions, it would be best to abandon this
thread and start a new one on that list.

-Kevin