Re: Why won't it index scan?

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why won't it index scan?
Date: 2006-05-17 17:00:43
Message-ID: abcc5c6623f479d60302af9b4e788bce@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ed L. wrote:

> Can someone help me understand why the 8.1.2 query below is
> using a seq scan instead of an index scan?

Because the planner thinks a sequential scan would be faster than an
index scan - in many situations, this is the case. See the FAQ:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.6

- John Burger
MITRE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-05-17 17:01:28 Re: DB structure of PostGRE
Previous Message Tom Lane 2006-05-17 16:59:13 Re: [GENERAL] Querying libpq compile time options