Re: Strange Index behavior - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Strange Index behavior
Date
Msg-id 20041222181115.GA500@wolff.to
Whole thread Raw
In response to Re: Strange Index behavior  (Együd Csaba (Freemail) <csegyud@freemail.hu>)
List pgsql-general
On Wed, Dec 22, 2004 at 18:44:00 +0100,
  "Együd Csaba (Freemail)" <csegyud@freemail.hu> wrote:
> But why? I thought the planner is for choose the quicker way to the target
> point. If there is an index which is probably would speed up the query then
> why does the planner ignore that?

Because doing an index scan is slower if you are retrieving a significant
(very roughly 5%) fraction of a table.

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: 8.0 Beta3 worked, RC1 didn't!
Next
From: "A. Mous"
Date:
Subject: Re: 8.0 Beta3 worked, RC1 didn't!