On Wed, Aug 31, 2011 at 11:53 PM, Kevin Grittner < kevin.gritt...@wicourts.gov> wrote:
> Viktor Bojovi*<viktor.bojo...@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 > "analyze entry" has solved the problem. Thanx a lot. -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me
