Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E48761337B83 for ; Wed, 19 Jan 2011 13:27:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 88304-01 for ; Wed, 19 Jan 2011 17:26:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 4B1DF1337B7E for ; Wed, 19 Jan 2011 13:26:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p0JHQuca021793; Wed, 19 Jan 2011 12:26:56 -0500 (EST) To: Achilleas Mantzios cc: pgsql-performance@postgresql.org Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2 In-reply-to: <201101191110.05268.achill@matrix.gatewaynet.com> References: <955263366.48014741295283147090.JavaMail.root@ucimail4.uci.cu> <201101181006.03790.achill@matrix.gatewaynet.com> <4D35A30D.4030404@vmsinfo.com> <201101191110.05268.achill@matrix.gatewaynet.com> Comments: In-reply-to Achilleas Mantzios message dated "Wed, 19 Jan 2011 11:10:05 +0200" Date: Wed, 19 Jan 2011 12:26:56 -0500 Message-ID: <21792.1295458016@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/169 X-Sequence-Number: 41956 Achilleas Mantzios writes: > Anyway, i will repost the EXPLAIN plans by copying pasting the query, without the analyze part. Please show EXPLAIN ANALYZE, not just EXPLAIN, results. When complaining that the planner did the wrong thing, it's not very helpful to see only its estimates and not reality. regards, tom lane