Re: Wrong plan for simple join with index on FK

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Wrong plan for simple join with index on FK
Date: 2006-05-16 10:10:46
Message-ID: 20060516101046.GC976@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2006-05-16 10:54:58 Re: Wrong plan for simple join with index on FK
Previous Message Martijn van Oosterhout 2006-05-16 10:00:05 Re: Creating a Pseudocolumn