On Wed, Dec 14, 2011 at 4:53 PM, Maxim Boguk <maxim.bo...@gmail.com> wrote: > Here goes self-contained test case. > > I tested it on the 9.1.2, 9.1.1, 9.0.5, 9.0.4, 8.4.7
I just tested on 9.1.2 and see the same issue. > --bad > EXPLAIN ANALYZE select * > from test1 > where > test1.user_id in (100, 101) > and exists ( > SELECT * from test2 > join test3 using (resume_id) > where > test2.user_id = test1.user_id > ); Setting enable_hashjoin to false pushes it back to a good plan again. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
