[PERFORM] Nested Loop join being improperly chosen

[Brad Ediger]

Hello,



Here are the plans with and without enable_nestloop:

http://pastie.org/258043



Any ideas or suggestions would be greatly appreciated. Thanks!
--
Brad Ediger

I'm having trouble with a Nested Loop being selected for a rather complex query; it turns out this is a pretty bad plan as the nested loop's row estimates are quite off (1 estimated / 1207881 actual). If I disable enable_nestloop, the query executes much faster (42 seconds instead of 605). The tables in the query have all been ANALYZEd just before generating these plans. The inventory table is huge; it currently has about 1.3 x 10^9 tuples. The items table has around 10,000 tuples, and the other tables in the query are tiny.

smime.p7s
Description: S/MIME cryptographic signature