Re: Strange Index behavior

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu>
Cc: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 'Együd Csaba' <csegyud(at)vnet(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange Index behavior
Date: 2004-12-22 18:11:15
Message-ID: 20041222181115.GA500@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 22, 2004 at 18:44:00 +0100,
"Együd Csaba (Freemail)" <csegyud(at)freemail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2004-12-22 18:44:11 Re: What HW / OS is recommeded
Previous Message Scott Marlowe 2004-12-22 18:09:43 Re: What HW / OS is recommeded