Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q8oWA-0001ne-WD for pgsql-performance@arkaria.postgresql.org; Mon, 12 Jun 2023 20:52:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q8oVB-00062F-Ie for pgsql-performance@arkaria.postgresql.org; Mon, 12 Jun 2023 20:51:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q8oVB-000626-84 for pgsql-performance@lists.postgresql.org; Mon, 12 Jun 2023 20:51:01 +0000 Received: from 6.mo548.mail-out.ovh.net ([188.165.58.48]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q8oV3-001qf7-HU for pgsql-performance@lists.postgresql.org; Mon, 12 Jun 2023 20:50:59 +0000 Received: from mxplan6.mail.ovh.net (unknown [10.109.156.148]) by mo548.mail-out.ovh.net (Postfix) with ESMTPS id 6026920C77; Mon, 12 Jun 2023 20:50:51 +0000 (UTC) Received: from DAG6EX1.mxp6.local (172.16.2.51) by DAG6EX1.mxp6.local (172.16.2.51) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2507.23; Mon, 12 Jun 2023 22:50:51 +0200 Received: from DAG6EX1.mxp6.local ([fe80::f5b3:cd71:6d1d:f0e0]) by DAG6EX1.mxp6.local ([fe80::f5b3:cd71:6d1d:f0e0%5]) with mapi id 15.01.2507.023; Mon, 12 Jun 2023 22:50:50 +0200 From: benoit To: Peter Geoghegan CC: "pgsql-performance@lists.postgresql.org" Subject: RE: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Thread-Topic: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Thread-Index: AQHZnWrs4DK20zdnFU+lNA3FhF+aJa+Hfk4AgAAlvlU= Date: Mon, 12 Jun 2023 20:50:50 +0000 Message-ID: <6551f5840dc44882bdac1475526ebfc9@hopsandfork.com> References: <7e0c07696f3f42189815f28c898c3133@hopsandfork.com>, In-Reply-To: Accept-Language: fr-FR, en-US Content-Language: fr-FR X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [37.59.142.68] x-ovh-tracer-guid: 1048395d-9923-4437-ab59-7373606b8b28 x-ovh-tracer-id: 9595763432564280730 Content-Type: multipart/alternative; boundary="_000_6551f5840dc44882bdac1475526ebfc9hopsandforkcom_" MIME-Version: 1.0 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: -100 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgedvhedrgeduhedgudehfecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpefhvfevufhtfffkfhgjihgtggesrgdtjhertddtjeenucfhrhhomhepsggvnhhoihhtuceosggvnhhoihhtsehhohhpshgrnhgufhhorhhkrdgtohhmqeenucggtffrrghtthgvrhhnpedugfejueeghfejueffffdtheeuledvgeehgeejudfgjedvteehueekueffjeetkeenucffohhmrghinhepuggrlhhisghordgtohhmnecukfhppeduvdejrddtrddtrddupdefjedrheelrddugedvrdeikeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeduvdejrddtrddtrddupdhmrghilhhfrhhomhepoegsvghnohhitheshhhophhsrghnughfohhrkhdrtghomheqpdhnsggprhgtphhtthhopedupdhrtghpthhtohepphhgsegsohifthdrihgvpdhpghhsqhhlqdhpvghrfhhorhhmrghntggvsehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdpoffvtefjohhsthepmhhoheegkedpmhhouggvpehsmhhtphhouhht List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_6551f5840dc44882bdac1475526ebfc9hopsandforkcom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 U2FkbHkgaXQgZG9lc24ndCBoZWxwIHRvIGRpc2FibGUgaW5kZXhzY2FuLiBUaGUgcGxhbiA6IGh0 dHBzOi8vZXhwbGFpbi5kYWxpYm8uY29tL3BsYW4vM2IzZ2ZjZTViMjljM2hoNA0KDQpfX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fXw0KRGUgOiBQZXRlciBHZW9naGVnYW4gPHBnQGJvd3Qu aWU+DQpFbnZvecOpIDogbHVuZGkgMTIganVpbiAyMDIzIDIyOjM0OjUwDQrDgCA6IGJlbm9pdA0K Q2MgOiBwZ3NxbC1wZXJmb3JtYW5jZUBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0KT2JqZXQgOiBSZTog Rm9yY2VkIHRvIHVzZSBVTklPTiBBTEwgd2hlbiBoYXZpbmcgbXVsdGlwbGUgQU5ZIG9wZXJhdG9y cyBhbmQgT1JERVIgQlkgTElNSVQNCg0KT24gTW9uLCBKdW4gMTIsIDIwMjMgYXQgMToxN+KAr1BN IGJlbm9pdCA8YmVub2l0QGhvcHNhbmRmb3JrLmNvbT4gd3JvdGU6DQo+IElzIHRoZXJlIGEgbWlz dXNhZ2Ugb2YgbXkgaW5kZXhlcz8NCj4NCj4gSXMgdGhlcmUgYSBsaW1pdGF0aW9uIHdoZW4gdXNp bmcgQU5ZIG9yIElOIG9wZXJhdG9ycyBhbmQgb3JkZXJlZCBMSU1JVCBiZWhpbmQ/DQoNCkl0J3Mg Y29tcGxpY2F0ZWQuIERvIHlvdSBmaW5kIHRoYXQgeW91IGdldCBzYXRpc2ZhY3RvcnkgcGVyZm9y bWFuY2UgaWYNCnlvdSBmb3JjZSBhIGJpdG1hcCBpbmRleCBzY2FuPyBJbiBvdGhlciB3b3Jkcywg d2hhdCBpcyB0aGUgZWZmZWN0IG9mDQoic2V0IGVuYWJsZV9pbmRleHNjYW4gPSBvZmYiIG9uIHlv dXIgb3JpZ2luYWwgcXVlcnk/IERvZXMgdGhhdCBzcGVlZA0KdXAgZXhlY3V0aW9uIGF0IGFsbD8g KEkgdGhpbmsgdGhhdCB0aGlzIGFwcHJvYWNoIG91Z2h0IHRvIHByb2R1Y2UgYQ0KcGxhbiB0aGF0 IHVzZXMgYSBiaXRtYXAgaW5kZXggc2NhbiBpbiBwbGFjZSBvZiB0aGUgaW5kZXggc2Nhbiwgd2l0 aG91dA0KY2hhbmdpbmcgYW55dGhpbmcgZWxzZS4pDQoNCi0tDQpQZXRlciBHZW9naGVnYW4NCg== --_000_6551f5840dc44882bdac1475526ebfc9hopsandforkcom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRvciIgY29udGVu dD0iTWljcm9zb2Z0IEV4Y2hhbmdlIFNlcnZlciI+DQo8IS0tIGNvbnZlcnRlZCBmcm9tIHRleHQg LS0+PHN0eWxlPjwhLS0gLkVtYWlsUXVvdGUgeyBtYXJnaW4tbGVmdDogMXB0OyBwYWRkaW5nLWxl ZnQ6IDRwdDsgYm9yZGVyLWxlZnQ6ICM4MDAwMDAgMnB4IHNvbGlkOyB9IC0tPjwvc3R5bGU+DQo8 L2hlYWQ+DQo8Ym9keT4NCjxtZXRhIGNvbnRlbnQ9InRleHQvaHRtbDsgY2hhcnNldD1VVEYtOCI+ DQo8c3R5bGUgdHlwZT0idGV4dC9jc3MiIHN0eWxlPSIiPg0KPCEtLQ0KcA0KCXttYXJnaW4tdG9w OjA7DQoJbWFyZ2luLWJvdHRvbTowfQ0KLS0+DQo8L3N0eWxlPg0KPGRpdiBkaXI9Imx0ciI+DQo8 ZGl2IGlkPSJ4X2RpdnRhZ2RlZmF1bHR3cmFwcGVyIiBkaXI9Imx0ciIgc3R5bGU9ImZvbnQtc2l6 ZToxMnB0OyBjb2xvcjojMDAwMDAwOyBmb250LWZhbWlseTpDYWxpYnJpLEhlbHZldGljYSxzYW5z LXNlcmlmIj4NCjxwPlNhZGx5IGl0IGRvZXNuJ3QgaGVscCB0byBkaXNhYmxlIGluZGV4c2Nhbi4g VGhlIHBsYW4gOiZuYnNwOzxhIGhyZWY9Imh0dHBzOi8vZXhwbGFpbi5kYWxpYm8uY29tL3BsYW4v M2IzZ2ZjZTViMjljM2hoNCIgY2xhc3M9InhfT1dBQXV0b0xpbmsiIGlkPSJMUGxuazc3MjQxMiI+ aHR0cHM6Ly9leHBsYWluLmRhbGliby5jb20vcGxhbi8zYjNnZmNlNWIyOWMzaGg0PC9hPjwvcD4N CjwvZGl2Pg0KPGhyIHRhYmluZGV4PSItMSIgc3R5bGU9ImRpc3BsYXk6aW5saW5lLWJsb2NrOyB3 aWR0aDo5OCUiPg0KPGRpdiBpZD0ieF9kaXZScGx5RndkTXNnIiBkaXI9Imx0ciI+PGZvbnQgZmFj ZT0iQ2FsaWJyaSwgc2Fucy1zZXJpZiIgY29sb3I9IiMwMDAwMDAiIHN0eWxlPSJmb250LXNpemU6 MTFwdCI+PGI+RGUgOjwvYj4gUGV0ZXIgR2VvZ2hlZ2FuICZsdDtwZ0Bib3d0LmllJmd0Ozxicj4N CjxiPkVudm95w6kgOjwvYj4gbHVuZGkgMTIganVpbiAyMDIzIDIyOjM0OjUwPGJyPg0KPGI+w4Ag OjwvYj4gYmVub2l0PGJyPg0KPGI+Q2MmbmJzcDs6PC9iPiBwZ3NxbC1wZXJmb3JtYW5jZUBsaXN0 cy5wb3N0Z3Jlc3FsLm9yZzxicj4NCjxiPk9iamV0IDo8L2I+IFJlOiBGb3JjZWQgdG8gdXNlIFVO SU9OIEFMTCB3aGVuIGhhdmluZyBtdWx0aXBsZSBBTlkgb3BlcmF0b3JzIGFuZCBPUkRFUiBCWSBM SU1JVDwvZm9udD4NCjxkaXY+Jm5ic3A7PC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPGZvbnQgc2l6 ZT0iMiI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMHB0OyI+DQo8ZGl2IGNsYXNzPSJQbGFpblRl eHQiPk9uIE1vbiwgSnVuIDEyLCAyMDIzIGF0IDE6MTfigK9QTSBiZW5vaXQgJmx0O2Jlbm9pdEBo b3BzYW5kZm9yay5jb20mZ3Q7IHdyb3RlOjxicj4NCiZndDsgSXMgdGhlcmUgYSBtaXN1c2FnZSBv ZiBteSBpbmRleGVzPzxicj4NCiZndDs8YnI+DQomZ3Q7IElzIHRoZXJlIGEgbGltaXRhdGlvbiB3 aGVuIHVzaW5nIEFOWSBvciBJTiBvcGVyYXRvcnMgYW5kIG9yZGVyZWQgTElNSVQgYmVoaW5kPzxi cj4NCjxicj4NCkl0J3MgY29tcGxpY2F0ZWQuIERvIHlvdSBmaW5kIHRoYXQgeW91IGdldCBzYXRp c2ZhY3RvcnkgcGVyZm9ybWFuY2UgaWY8YnI+DQp5b3UgZm9yY2UgYSBiaXRtYXAgaW5kZXggc2Nh bj8gSW4gb3RoZXIgd29yZHMsIHdoYXQgaXMgdGhlIGVmZmVjdCBvZjxicj4NCiZxdW90O3NldCBl bmFibGVfaW5kZXhzY2FuID0gb2ZmJnF1b3Q7IG9uIHlvdXIgb3JpZ2luYWwgcXVlcnk/IERvZXMg dGhhdCBzcGVlZDxicj4NCnVwIGV4ZWN1dGlvbiBhdCBhbGw/IChJIHRoaW5rIHRoYXQgdGhpcyBh cHByb2FjaCBvdWdodCB0byBwcm9kdWNlIGE8YnI+DQpwbGFuIHRoYXQgdXNlcyBhIGJpdG1hcCBp bmRleCBzY2FuIGluIHBsYWNlIG9mIHRoZSBpbmRleCBzY2FuLCB3aXRob3V0PGJyPg0KY2hhbmdp bmcgYW55dGhpbmcgZWxzZS4pPGJyPg0KPGJyPg0KLS0gPGJyPg0KUGV0ZXIgR2VvZ2hlZ2FuPGJy Pg0KPC9kaXY+DQo8L3NwYW4+PC9mb250Pg0KPC9ib2R5Pg0KPC9odG1sPg0K --_000_6551f5840dc44882bdac1475526ebfc9hopsandforkcom_--