Postgres Pro
Downloads
Home   >   mailing lists

Re: Why won't it index scan? - Mailing list pgsql-general

From John D. Burger
Subject Re: Why won't it index scan?
Date
Msg-id abcc5c6623f479d60302af9b4e788bce@mitre.org
Whole thread Raw
In response to Why won't it index scan?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Why won't it index scan?
Next
From: Tom Lane
Date:
Subject: Re: DB structure of PostGRE