Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jD8Yt-0002kE-Ma for pgsql-committers@arkaria.postgresql.org; Sat, 14 Mar 2020 15:18:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1jD8Ys-0005Hy-GH for pgsql-committers@arkaria.postgresql.org; Sat, 14 Mar 2020 15:18:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jD8Vw-0003OH-6Z for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2020 15:15:48 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jD8Vs-0004S7-UV for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2020 15:15:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=sE5Hr+UcckXXDQ55CYnolj/8qdQLHxvLtU+0Pfn6Ess=; b=CHzxSaPyY9AjMmmbO9DCrofyuN EZU/Hrqd3j2V3HvkS3PuDLUTaH5U7tThJCBwBvJxJrN2YK2EUMBltIfUu9pxtETuGxL6PbRJamW2w MTM2EECWRLVS6RWwCqM2RO6ZDh3AbodG7Vbs0J/FPcbpxMYEzkCjoAYB/+98vB6rDBFY7DKjh91xn m1QzZEwxxGAWmhPLTOPo1lFRQkW0n1TuvFHwg9zt3Z2nEVivbEn/+Qy3VA00z1aFPkoGewA04/gYo zw9PC+OkscetyTTYOUphJYvlvzqkjn7RahsG1TBsz+uEFgJv1b2ykUiBrM/s92FXMKYNc09B4DVYy JTgVKOjw==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1jD8Vs-0006Er-IS for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2020 15:15:44 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jD8Vr-0007rw-Qa for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2020 15:15:43 +0000 Content-Type: multipart/mixed; boundary="===============3613118564663846831==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use multi-variate MCV lists to estimate ScalarArrayOpExpr Message-Id: Date: Sat, 14 Mar 2020 15:15:43 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3613118564663846831== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIG11bHRpLXZhcmlhdGUgTUNWIGxpc3RzIHRvIGVzdGltYXRlIFNjYWxhckFycmF5T3BFeHBy CgpDb21taXQgOGYzMjFiZDE2YyBhZGRlZCBzdXBwb3J0IGZvciBlc3RpbWF0aW5nIFNjYWxhckFy cmF5T3BFeHByIGNsYXVzZXMKKElOL0FOWSkgY2xhdXNlcyB1c2luZyBmdW5jdGlvbmFsIGRlcGVu ZGVuY2llcy4gVGhlcmUncyBubyBnb29kIHJlYXNvbgpub3QgdG8gc3VwcG9ydCBlc3RpbWF0aW9u IG9mIHRoZXNlIGNsYXVzZXMgdXNpbmcgbXVsdGktdmFyaWF0ZSBNQ1YgbGlzdHMKdG9vLCBzbyB0 aGlzIGNvbW1pdHMgaW1wbGVtZW50cyB0aGF0LiBUaGF0IG1ha2VzIHRoZSBiZWhhdmlvciBjb25z aXN0ZW50CmFuZCBNQ1YgbGlzdHMgY2FuIGVzdGltYXRlIGFsbCB2YXJpYW50cyAoQU5ZL0FMTCwg aW5lcXVhbGl0aWVzLCAuLi4pLgoKQXV0aG9yOiBUb21hcyBWb25kcmEKUmV2aWV3OiBEZWFuIFJh c2hlZWQKRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC9m bGF0LzEzOTAyMzE3LkVoYTBZZktrS3klNDBwaWVycmVkLXBkb2MKCkJyYW5jaAotLS0tLS0KbWFz dGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0 ZGlmZi9lODNkYWE3ZTMzMWUwNzE4YmIyNTRhYjY4NWYyZWQ5NWRmNDIzNTU0CgpNb2RpZmllZCBG aWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9zdGF0aXN0aWNzL2V4dGVuZGVkX3N0YXRz LmMgICAgICAgICAgfCAgNjYgKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvc3RhdGlzdGljcy9t Y3YuYyAgICAgICAgICAgICAgICAgICAgIHwgMTExICsrKysrKysrKysrKysrKysrKysrKystCnNy Yy9pbmNsdWRlL3N0YXRpc3RpY3MvZXh0ZW5kZWRfc3RhdHNfaW50ZXJuYWwuaCB8ICAgNCArLQpz cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N0YXRzX2V4dC5vdXQgICAgICAgICAgfCAgNjAgKysr KysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0YXRzX2V4dC5zcWwgICAgICAgICAgICAg ICB8ICAyMCArKysrCjUgZmlsZXMgY2hhbmdlZCwgMjUyIGluc2VydGlvbnMoKyksIDkgZGVsZXRp b25zKC0pCgo= --===============3613118564663846831==--