Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange Index behavior - Mailing list pgsql-general

From Tom Lane
Subject Re: Strange Index behavior
Date
Msg-id 5322.1103736855@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange Index behavior  (Együd Csaba (Freemail) <csegyud@freemail.hu>)
Responses Re: Strange Index behavior  (Együd Csaba (Freemail) <csegyud@freemail.hu>)
List pgsql-general
Tree view 
=?iso-8859-2?Q?Egy=FCd_Csaba_=28Freemail=29?= <csegyud@freemail.hu> writes:
> The point is that there are cases where a primary key index is not used -
> even if the condition is formaly good.

You haven't actually shown us such a case.  In the case you gave,
I think the planner probably made the right choice not to use the index.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: default index created for primary key
Next
From: Lonni J Friedman
Date:
Subject: Re: What HW / OS is recommeded