Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XiUBg-0005kD-Sx for pgsql-committers@arkaria.postgresql.org; Sun, 26 Oct 2014 20:13:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XiUBf-0001zw-KQ for pgsql-committers@arkaria.postgresql.org; Sun, 26 Oct 2014 20:13:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XiUBW-0001lg-4F for pgsql-committers@postgresql.org; Sun, 26 Oct 2014 20:13:06 +0000 Received: from mahout.postgresql.org ([2001:4800:1501:1::227]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XiUBR-0003ci-73 for pgsql-committers@postgresql.org; Sun, 26 Oct 2014 20:13:04 +0000 Received: from gemulon.postgresql.org ([2001:4800:1501:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1XiUBO-0003Ce-CY for pgsql-committers@postgresql.org; Sun, 26 Oct 2014 20:12:58 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.80) (envelope-from ) id 1XiUBH-0000ck-RT for pgsql-committers@postgresql.org; Sun, 26 Oct 2014 20:12:51 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Improve planning of btree index scans using ScalarArrayOpExpr qu Message-Id: Date: Sun, 26 Oct 2014 20:12:51 +0000 X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-committers Precedence: bulk Sender: pgsql-committers-owner@postgresql.org SW1wcm92ZSBwbGFubmluZyBvZiBidHJlZSBpbmRleCBzY2FucyB1c2luZyBT Y2FsYXJBcnJheU9wRXhwciBxdWFscy4KClNpbmNlIHdlIHRhdWdodCBidHJl ZSB0byBoYW5kbGUgU2NhbGFyQXJyYXlPcEV4cHIgcXVhbHMgbmF0aXZlbHkg KGNvbW1pdAo5ZThkYTBmNzU3MzFhYWE3NjA1Y2Y0NjU2YzIxZWEwOWU4NGQy ZWIxKSwgdGhlIHBsYW5uZXIgaGFzIGFsd2F5cyBpbmNsdWRlZApTY2FsYXJB cnJheU9wRXhwciBxdWFscyBpbiBpbmRleCBjb25kaXRpb25zIGlmIHBvc3Np YmxlLiAgSG93ZXZlciwgaWYgdGhlCnF1YWwgaXMgZm9yIGEgbm9uLWZpcnN0 IGluZGV4IGNvbHVtbiwgdGhpcyBjb3VsZCByZXN1bHQgaW4gYW4gaW5mZXJp b3IgcGxhbgpiZWNhdXNlIHdlIGNhbiBubyBsb25nZXIgdGFrZSBhZHZhbnRh Z2Ugb2YgaW5kZXggb3JkZXJpbmcgKGNmLiBjb21taXQKODA3YTQwYzU1MWRk MzBjOGRkNWEwYjNiZDgyZjViYmIxZTdmZDI4NSkuICBJdCBjYW4gYmUgYmV0 dGVyIHRvIG9taXQgdGhlClNjYWxhckFycmF5T3BFeHByIHF1YWwgZnJvbSB0 aGUgaW5kZXggY29uZGl0aW9uIGFuZCBsZXQgaXQgYmUgZG9uZSBhcyBhCmZp bHRlciwgc28gdGhhdCB0aGUgb3V0cHV0IGRvZXNuJ3QgbmVlZCB0byBnZXQg c29ydGVkLiAgSW5kZWVkLCB0aGlzIGlzCnRydWUgZm9yIHRoZSBxdWVyeSBp bnRyb2R1Y2VkIGFzIGEgdGVzdCBjYXNlIGJ5IHRoZSBsYXR0ZXIgY29tbWl0 LgoKVG8gZml4LCByZXN0cnVjdHVyZSBnZXRfaW5kZXhfcGF0aHMgYW5kIGJ1 aWxkX2luZGV4X3BhdGhzIHNvIHRoYXQgd2UKY29uc2lkZXIgcGF0aHMgYm90 aCB3aXRoIGFuZCB3aXRob3V0IFNjYWxhckFycmF5T3BFeHByIHF1YWxzIGlu IG5vbi1maXJzdAppbmRleCBjb2x1bW5zLiAgUmVkZXNpZ24gdGhlIEFQSSBv ZiBidWlsZF9pbmRleF9wYXRocyBzbyB0aGF0IGl0IHJlcG9ydHMKd2hhdCBp dCBmb3VuZCwgc2F2aW5nIHVzZWxlc3Mgc2Vjb25kIG9yIHRoaXJkIGNhbGxz LgoKUmVwb3J0IGFuZCBwYXRjaCBieSBBbmRyZXcgR2llcnRoICh0aG91Z2gg cmF0aGVyIGhlYXZpbHkgbW9kaWZpZWQgYnkgbWUpLgpCYWNrLXBhdGNoIHRv IDkuMiB3aGVyZSB0aGlzIGNvZGUgd2FzIGludHJvZHVjZWQsIHNpbmNlIHRo ZSBpc3N1ZSBjYW4KcmVzdWx0IGluIHNpZ25pZmljYW50IHBlcmZvcm1hbmNl IHJlZ3Jlc3Npb25zIGNvbXBhcmVkIHRvIHBsYW5zIHByb2R1Y2VkCmJ5IDku MSBhbmQgZWFybGllci4KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxz Ci0tLS0tLS0KaHR0cDovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRk aWZmL2E0NTIzYzVhYTUzNDk1MTBkZGI3NGFiZGRjNDE2YWRkMjUzNmVjM2QK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL29w dGltaXplci9wYXRoL2luZHhwYXRoLmMgICAgICB8ICAxMTYgKysrKysrKysr KysrKysrKysrLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVk L2NyZWF0ZV9pbmRleC5vdXQgfCAgIDI0ICsrKysrLQpzcmMvdGVzdC9yZWdy ZXNzL3NxbC9jcmVhdGVfaW5kZXguc3FsICAgICAgfCAgIDEzICsrKysKMyBm aWxlcyBjaGFuZ2VkLCAxMTIgaW5zZXJ0aW9ucygrKSwgNDEgZGVsZXRpb25z KC0pCgoKLS0gClNlbnQgdmlhIHBnc3FsLWNvbW1pdHRlcnMgbWFpbGluZyBs aXN0IChwZ3NxbC1jb21taXR0ZXJzQHBvc3RncmVzcWwub3JnKQpUbyBtYWtl IGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246Cmh0dHA6Ly93d3cucG9z dGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtY29tbWl0dGVycwo=