Re: function based index problem

On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner <
Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:

> Viktor Bojovi*<viktor(dot)bojovic(at)gmail(dot)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
>

"analyze entry" has solved the problem. Thanx a lot.

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me