X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 32F21D1EF8E for ; Mon, 3 May 2004 13:31:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38650-03 for ; Mon, 3 May 2004 13:30:48 -0300 (ADT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 72638D1EF8C for ; Mon, 3 May 2004 13:30:43 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 641033AA01; Mon, 3 May 2004 13:30:50 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 592213A947 for ; Mon, 3 May 2004 13:30:50 -0300 (ADT) X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.3) with LMTP; Mon, 03 May 2004 13:10:38 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 734C73A64D for ; Mon, 3 May 2004 13:10:36 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Mon, 03 May 2004 13:10:36 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.3) with LMTP; Mon, 03 May 2004 13:08:37 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1EEE4D1EF81 for ; Mon, 3 May 2004 13:08:37 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 25024-06 for ; Mon, 3 May 2004 13:08:19 -0300 (ADT) X-Received: from smtprelay02.ispgateway.de (smtprelay02.ispgateway.de [62.67.200.157]) by svr1.postgresql.org (Postfix) with ESMTP id 465D3D1EF7B for ; Mon, 3 May 2004 13:08:13 -0300 (ADT) X-Received: (qmail 19882 invoked from network); 3 May 2004 16:08:17 -0000 X-Received: from unknown (HELO tcn.local) ([pbs]652696@[217.93.30.36]) (envelope-sender ) by smtprelay02.ispgateway.de (qmail-ldap-1.03) with AES256-SHA encrypted SMTP for ; 3 May 2004 16:08:17 -0000 X-Received: from [127.0.0.1] (localhost [127.0.0.1]) by tcn.local (Postfix) with ESMTP id 947B6AB9 for ; Mon, 3 May 2004 18:08:23 +0200 (CEST) Message-ID: <40966E77.4020004@nitwit.de> Date: Mon, 03 May 2004 18:08:23 +0200 From: Timo Nentwig User-Agent: Mozilla Thunderbird 0.6 (X11/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: support@postgresql.org Subject: Bug in optimizer X-Enigmail-Version: 0.83.6.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Mon, 3 May 2004 13:30:46 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-bugs@postgresql.org ReSent-Subject: Bug in optimizer ReSent-Message-ID: <20040503133046.V22860@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=BIZ_TLD, UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200405/26 X-Sequence-Number: 8298 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi! Your bug report form on the web doesn't work. This is very slow: SELECT urls.id FROM urls WHERE ( urls.id <> ALL (SELECT html.urlid FROM html) ); ...while this is quite fast: SELECT urls.id FROM urls WHERE ( NOT (EXISTS (SELECT html.urlid FROM tml WHERE ( html.urlid = urls.id ))) ); Regards Timo - -- http://nentwig.biz/ (J2EE) http://nitwit.de/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQFAlm53cmRm71Um+e0RAkJuAKChd+6zoFesZfBY/cGRsSVagnJeswCeMD5s ++Es8hVsFlUpkIIsRfrBp4Y= =STbS -----END PGP SIGNATURE-----