Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D0A7564FDA5 for ; Wed, 19 Nov 2008 10:55:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 75503-08 for ; Wed, 19 Nov 2008 10:55:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.29]) by mail.postgresql.org (Postfix) with ESMTP id 28A5864FC5A for ; Wed, 19 Nov 2008 10:55:25 -0400 (AST) Received: by yx-out-2324.google.com with SMTP id 8so1419183yxb.73 for ; Wed, 19 Nov 2008 06:55:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=KhMzXCxqtnqLUDycIOQhJU/vghX4Yp7BXxVrkjRecv4=; b=ncoe/ZY6rJ2QRcLXxlwx0cA752XQ6ZxF3gVh2xYRD/gkybP92hhvRJeULLFKdOS8uZ 13y6i5Bb5bHtyf4deaCsozOV+Azmie9DEcZv+KnuzqfEVuMkE5Z7qw73dklCJK+7BZ7V 5m9NH284ebjUYA9OZgHa6xsVB5JbLkXC9eYbU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=OKz5JgzbdltzD1iOeupIRIVbqAEuCliPBfGo+uSdZ+M/dgJEzwKHTiPo3b+bElqpgi V0NPRg3n3GFL7XiOq6MI/YWUvim0HlkGYWYlLuVwtsFLGEYZQdazVADrtb7A3LpZJ+gq UL7HiNAK5hYJXJKwmsRes4cdJ4OdkQ9KbiuKk= Received: by 10.65.135.19 with SMTP id m19mr1144146qbn.77.1227106518844; Wed, 19 Nov 2008 06:55:18 -0800 (PST) Received: by 10.65.22.1 with HTTP; Wed, 19 Nov 2008 06:55:18 -0800 (PST) Message-ID: <331e40660811190655xccd1752rcb1ac7769e5cc8a4@mail.gmail.com> Date: Wed, 19 Nov 2008 16:55:18 +0200 From: "=?ISO-8859-5?B?svbi0Nv22SDC2Nzn2OjY3Q==?=" To: "Stephan Szabo" Subject: Re: PostgreSQL NOT IN performance Cc: pgsql-performance@postgresql.org In-Reply-To: <20081119062806.Y58658@megazone.bigpanda.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_75051_31855107.1227106518866" References: <331e40660811190351n6bde6caic5fd8cc3a0f777d2@mail.gmail.com> <20081119062806.Y58658@megazone.bigpanda.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200811/163 X-Sequence-Number: 31894 ------=_Part_75051_31855107.1227106518866 Content-Type: text/plain; charset=ISO-8859-5 Content-Transfer-Encoding: base64 Content-Disposition: inline MjAwOC8xMS8xOSBTdGVwaGFuIFN6YWJvIDxzc3phYm9AbWVnYXpvbmUuYmlncGFuZGEuY29tPgoK Pgo+IE9uIFdlZCwgMTkgTm92IDIwMDgsIFtJU08tODg1OS01XSCy9uLQ2/bZIMLY3OfY6NjdIHdy b3RlOgo+Cj4gPiBRdWVyeSAxOgo+ID4gc2VsZWN0ICogZnJvbSB0MSB3aGVyZSBpZCBub3QgaW4g KHNlbGVjdCBpZCBmcm9tIHQyKTsKPiA+Cj4gPiBRdWVyeSAyIChnaXZlcyBzYW1lIHJlc3VsdCBh cyBRMSk6Cj4gPiBzZWxlY3QgKiBmcm9tIHQxIGV4Y2VwdCBhbGwgKHNlbGVjdCBpZCBmcm9tIHQy KTsKPgo+IEl0IGdpdmVzIHRoZSBzYW1lIHJlc3VsdCBhcyBsb25nIGFzIG5vIG51bGxzIGFyZSBp biBlaXRoZXIgdGFibGUuIElmCj4gZWl0aGVyIHRhYmxlIGNhbiBoYXZlIGEgbnVsbCwgdGhlIGNv bnZlcnNpb24gY2hhbmdlcyB0aGUgcmVzdWx0cy4KPgo+IEluIGFkZGl0aW9uLCBhIGNvbnZlcnNp b24gbGlrZSB0aGUgYWJvdmUgb25seSBoYXBwZW5zIHRvIHdvcmsgYmVjYXVzZSB0MQo+IG9ubHkg aGFzIGFuIGlkIGNvbHVtbi4gSWYgdDEgaGFkIHR3byBjb2x1bW5zIHlvdSdkIGdldCBhbiBlcnJv ciBiZWNhdXNlCj4gdGhlIHR3byBzaWRlcyBvZiBleGNlcHQgYWxsIG11c3QgaGF2ZSB0aGUgc2Ft ZSBudW1iZXIgb2YgY29sdW1ucy4KPgoKQWN0dWFsbHkgSXQgY2FuIGJlIGRvbmUgZXZlbiBmb3Ig bXVsdGktY29sdW1uIG1vZGUgaWYgdGhlIHNlbGVjdGlvbiBpcyBkb25lCm9uIHVuaXF1ZSBrZXku IEl0IHdvdWxkIGxvb2sgbGlrZToKCnNlbGVjdCAqIGZyb20gdDEgaW5uZXIgam9pbiAoCnNlbGVj dCBpZCBmcm9tIHQxIGV4Y2VwdCBzZWxlY3QgaWQgZnJvbSB0MikgdGFsaWFzIG9uIHQxLmlkID0g dGFsaWFzLmlkCgpBbmQgaXQgd291bGQgcHJvZHVjZSBiZXR0ZXIgcmVzdWx0cyB0aGVuICJub3Qg aW4iIGZvciBsYXJnZSBjb3VudHMgaW4gdDEgYW5kCnQyLgo= ------=_Part_75051_31855107.1227106518866 Content-Type: text/html; charset=ISO-8859-5 Content-Transfer-Encoding: base64 Content-Disposition: inline PGJyPjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+MjAwOC8xMS8xOSBTdGVwaGFuIFN6YWJv IDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEgaHJlZj0ibWFpbHRvOnNzemFib0BtZWdhem9uZS5iaWdw YW5kYS5jb20iPnNzemFib0BtZWdhem9uZS5iaWdwYW5kYS5jb208L2E+Jmd0Ozwvc3Bhbj48YnI+ PGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0iYm9yZGVyLWxlZnQ6IDFweCBz b2xpZCByZ2IoMjA0LCAyMDQsIDIwNCk7IG1hcmdpbjogMHB0IDBwdCAwcHQgMC44ZXg7IHBhZGRp bmctbGVmdDogMWV4OyI+CjxkaXYgY2xhc3M9IkloMkUzZCI+PGJyPgpPbiBXZWQsIDE5IE5vdiAy MDA4LCBbSVNPLTg4NTktNV0gsvbi0Nv22SDC2Nzn2OjY3SB3cm90ZTo8YnI+Cjxicj4KJmd0OyBR dWVyeSAxOjxicj4KJmd0OyBzZWxlY3QgKiBmcm9tIHQxIHdoZXJlIGlkIG5vdCBpbiAoc2VsZWN0 IGlkIGZyb20gdDIpOzxicj4KJmd0Ozxicj4KPC9kaXY+PGRpdiBjbGFzcz0iSWgyRTNkIj4mZ3Q7 IFF1ZXJ5IDIgKGdpdmVzIHNhbWUgcmVzdWx0IGFzIFExKTo8YnI+CiZndDsgc2VsZWN0ICogZnJv bSB0MSBleGNlcHQgYWxsIChzZWxlY3QgaWQgZnJvbSB0Mik7PGJyPgo8YnI+CjwvZGl2Pkl0IGdp dmVzIHRoZSBzYW1lIHJlc3VsdCBhcyBsb25nIGFzIG5vIG51bGxzIGFyZSBpbiBlaXRoZXIgdGFi bGUuIElmPGJyPgplaXRoZXIgdGFibGUgY2FuIGhhdmUgYSBudWxsLCB0aGUgY29udmVyc2lvbiBj aGFuZ2VzIHRoZSByZXN1bHRzLjxicj4KPGJyPgpJbiBhZGRpdGlvbiwgYSBjb252ZXJzaW9uIGxp a2UgdGhlIGFib3ZlIG9ubHkgaGFwcGVucyB0byB3b3JrIGJlY2F1c2UgdDE8YnI+Cm9ubHkgaGFz IGFuIGlkIGNvbHVtbi4gSWYgdDEgaGFkIHR3byBjb2x1bW5zIHlvdSYjMzk7ZCBnZXQgYW4gZXJy b3IgYmVjYXVzZTxicj4KdGhlIHR3byBzaWRlcyBvZiBleGNlcHQgYWxsIG11c3QgaGF2ZSB0aGUg c2FtZSBudW1iZXIgb2YgY29sdW1ucy48YnI+CjwvYmxvY2txdW90ZT48ZGl2Pjxicj5BY3R1YWxs eSBJdCBjYW4gYmUgZG9uZSBldmVuIGZvciBtdWx0aS1jb2x1bW4gbW9kZSBpZiB0aGUgc2VsZWN0 aW9uIGlzIGRvbmUgb24gdW5pcXVlIGtleS4gSXQgd291bGQgbG9vayBsaWtlOjxicj48YnI+c2Vs ZWN0ICogZnJvbSB0MSBpbm5lciBqb2luICg8YnI+c2VsZWN0IGlkIGZyb20gdDEgZXhjZXB0IHNl bGVjdCBpZCBmcm9tIHQyKSB0YWxpYXMgb24gPGEgaHJlZj0iaHR0cDovL3QxLmlkIj50MS5pZDwv YT4gPSA8YSBocmVmPSJodHRwOi8vdGFsaWFzLmlkIj50YWxpYXMuaWQ8L2E+PGJyPgo8YnI+QW5k IGl0IHdvdWxkIHByb2R1Y2UgYmV0dGVyIHJlc3VsdHMgdGhlbiAmcXVvdDtub3QgaW4mcXVvdDsg Zm9yIGxhcmdlIGNvdW50cyBpbiB0MSBhbmQgdDIuPGJyPjwvZGl2PjwvZGl2Pjxicj48c3BhbiBz dHlsZT0iZGlzcGxheTogbm9uZTsgdmlzaWJpbGl0eTogaGlkZGVuOyIgaWQ9Indpa0VkU2V0dXBG bGFnIj48L3NwYW4+PHNwYW4gc3R5bGU9ImRpc3BsYXk6IG5vbmU7IHZpc2liaWxpdHk6IGhpZGRl bjsiIGlkPSJ3aWtFZERpZmZTZXR1cEZsYWciPjwvc3Bhbj4K ------=_Part_75051_31855107.1227106518866--