Viktor Bojovi*<viktor.bojovic@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
