Re: [PERFORM] Nested Loop join being improperly chosen

2008-08-28 Thread Brad Ediger
On Aug 28, 2008, at 6:01 PM, David Rowley wrote: I had a similar problem here: http://archives.postgresql.org/pgsql-bugs/2008-07/msg00026.php Is the nested loop performing a LEFT join with yours? It's a little difficult to tell just from the query plan you showed. A work around for mine was to

[PERFORM] Nested Loop join being improperly chosen

2008-08-22 Thread Brad Ediger
s, and the other tables in the query are tiny. Any ideas or suggestions would be greatly appreciated. Thanks! -- Brad Ediger smime.p7s Description: S/MIME cryptographic signature