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.
signature.asc
Description: Digital signature
