Re: Query not using index despite high statistics

From: Henrik Zagerholm <henke(at)mac(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query not using index despite high statistics
Date: 2007-05-05 12:23:03
Message-ID: D750EFBB-5A8E-47F9-878B-4D33B4D1FDD0@mac.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


4 maj 2007 kl. 18:09 skrev Tom Lane:

> Henrik Zagerholm <henke(at)mac(dot)se> writes:
>> I have a SELECT query that uses Seq scans instead of index scan
>> despite that the index scan is faster.
>
> Try 8.2, it's a bit smarter about the costs of repeated indexscans
> on the inside of a nestloop.
>
Ahh sorry for forgetting the db version.
We are actually using 8.2.3.

Cheers, henrik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-05 14:48:04 Re: query not using index
Previous Message Steinar H. Gunderson 2007-05-05 09:30:59 Re: Feature Request --- was: PostgreSQL Performance Tuning