Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 2A0146337BE for ; Wed, 10 Mar 2010 09:43:55 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 82293-08 for ; Wed, 10 Mar 2010 13:43:36 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f228.google.com (mail-bw0-f228.google.com [209.85.218.228]) by mail.postgresql.org (Postfix) with ESMTP id 1369A633FF7 for ; Wed, 10 Mar 2010 09:43:43 -0400 (AST) Received: by bwz28 with SMTP id 28so423551bwz.34 for ; Wed, 10 Mar 2010 05:43:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=cGHCXsjepNiDjIkUx8EvQ1lSIm0801ygv1Tso9g0Joc=; b=UBAZF/D5hVlMpdIS7ZXyRWS2up467RAvLlZ0kTo+KQ1Oa0ef5p5bf0GJvWhVeM09LZ iFdskZZ9dWyWvNW4qDQK3h3/NDpVtuF4vycP3QSUN8BOU8uE9GdebyyvGcRgKR6wvSN+ 2UYURtF061/asskX0L6F+tDpwqtqsFqd06dnU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=M+a0wVT1iSt6rBhpuqGJBeTGn7Uhx4SsmDBPKCZdFaD5NSoeQPplrQ8w3iO0RR51i2 MROanYijdF0q2fGKrrlX7YF5YTpjK1QvanoXXYaICf5MVr46OJJ1KjOKlA8Ktlb3HRv5 dNuueLurGbgsrXUmNanFcA9LKaV0SEFQiIJbw= MIME-Version: 1.0 Received: by 10.204.134.6 with SMTP id h6mr1636149bkt.160.1268228621879; Wed, 10 Mar 2010 05:43:41 -0800 (PST) In-Reply-To: <20100310134342.GA29320@it.is.rice.edu> References: <4B979DFC.7080509@nuxeo.com> <20100310134342.GA29320@it.is.rice.edu> Date: Wed, 10 Mar 2010 13:43:41 +0000 Message-ID: <2f4958ff1003100543r4652fee2y1725b5f44882c7f6@mail.gmail.com> Subject: Re: Bad query plan inside EXISTS clause From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= To: Kenneth Marshall Cc: Benoit Delbosc , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=00151743f7f6804b040481727ca2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.36 tagged_above=-10 required=5 tests=AWL=-0.251, BAYES_05=-1.11, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/110 X-Sequence-Number: 37935 --00151743f7f6804b040481727ca2 Content-Type: text/plain; charset=UTF-8 try JOINs... --00151743f7f6804b040481727ca2 Content-Type: text/html; charset=UTF-8 try JOINs...

--00151743f7f6804b040481727ca2--