Re: [ADMIN] function based index problem

2011-08-31 Thread Viktor Bojović
On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner < kevin.gritt...@wicourts.gov> wrote: > Viktor Bojovi* 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

Re: [ADMIN] function based index problem

2011-08-31 Thread Kevin Grittner
Viktor Bojovi* 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 consi