Postgres Pro
Downloads
Home   >   mailing lists

Re: Wrong plan for simple join with index on FK - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Wrong plan for simple join with index on FK
Date
Msg-id 20060516101046.GC976@svana.org
Whole thread Raw
In response to Wrong plan for simple join with index on FK  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Responses Re: Wrong plan for simple join with index on FK
List pgsql-hackers
Tree view 
On Tue, May 16, 2006 at 11:52:05AM +0200, Pavel Stehule wrote:
> Hello
>
> I test using index on foreign key. I found situation, when planner choose
> worse plan.

Can we seen an EXPLAIN ANALYZE output to see where the miscalculation
lies. Is it underestimating the cost of the index scan, or
overestimating the cost of the hash join.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Creating a Pseudocolumn
Next
From: "Pavel Stehule"
Date:
Subject: Re: Wrong plan for simple join with index on FK