Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKL0M-000Kzc-Gl for pgsql-committers@arkaria.postgresql.org; Fri, 14 Jul 2023 15:46:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qKL0L-003zv2-5W for pgsql-committers@arkaria.postgresql.org; Fri, 14 Jul 2023 15:46:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKL0K-003zu2-Uo for pgsql-committers@lists.postgresql.org; Fri, 14 Jul 2023 15:46:48 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKL0G-000RnA-Kp for pgsql-committers@lists.postgresql.org; Fri, 14 Jul 2023 15:46:48 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qKL0F-0001cB-AL for pgsql-committers@lists.postgresql.org; Fri, 14 Jul 2023 15:46:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qKL0E-000Lin-3H for pgsql-committers@lists.postgresql.org; Fri, 14 Jul 2023 15:46:42 +0000 Content-Type: multipart/mixed; boundary="===============1088968998994303029==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Account for optimized MinMax aggregates during SS_finalize_plan. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 14 Jul 2023 15:46:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1088968998994303029== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWNjb3VudCBmb3Igb3B0aW1pemVkIE1pbk1heCBhZ2dyZWdhdGVzIGR1cmluZyBTU19maW5hbGl6 ZV9wbGFuLgoKV2UgYXJlIGNhcGFibGUgb2Ygb3B0aW1pemluZyBNSU4oKSBhbmQgTUFYKCkgYWdn cmVnYXRlcyBvbiBpbmRleGVkCmNvbHVtbnMgaW50byBzdWJxdWVyaWVzIHRoYXQgZXhwbG9pdCB0 aGUgaW5kZXgsIHJhdGhlciB0aGFuIHRoZSBub3JtYWwKdGhpbmcgb2Ygc2Nhbm5pbmcgdGhlIHdo b2xlIHRhYmxlLiAgV2hlbiB3ZSBkbyB0aGlzLCB3ZSByZXBsYWNlIHRoZQpBZ2dyZWYgbm9kZShz KSB3aXRoIFBhcmFtcyByZWZlcmVuY2luZyBzdWJxdWVyeSBvdXRwdXRzLiAgU3VjaCBQYXJhbXMK cmVhbGx5IG91Z2h0IHRvIGJlIGluY2x1ZGVkIGluIHRoZSBwZXItcGxhbi1ub2RlIGV4dFBhcmFt L2FsbFBhcmFtCnNldHMgY29tcHV0ZWQgYnkgU1NfZmluYWxpemVfcGxhbi4gIEhvd2V2ZXIsIHdl J3ZlIG5ldmVyIGRvbmUgc28KdXAgdG8gbm93IGJlY2F1c2Ugb2YgYW4gYW5jaWVudCBpbXBsZW1l bnRhdGlvbiBjaG9pY2UgdG8gcGVyZm9ybQp0aGF0IHN1YnN0aXR1dGlvbiBkdXJpbmcgc2V0X3Bs YW5fcmVmZXJlbmNlcywgd2hpY2ggcnVucyBhZnRlcgpTU19maW5hbGl6ZV9wbGFuLCBzbyB0aGF0 IFNTX2ZpbmFsaXplX3BsYW4gbmV2ZXIgc2VlcyB0aGVzZSBQYXJhbXMuCgpUaGlzIHNlZW1zIGxp a2UgY2xlYXJseSBhIGJ1ZywgeWV0IHRoZXJlIGhhdmUgYmVlbiBubyBmaWVsZCByZXBvcnRzCm9m IHByb2JsZW1zIHRoYXQgY291bGQgdHJhY2UgdG8gaXQuICBUaGlzIG1heSBiZSBiZWNhdXNlIHRo ZSB0eXBlcwpvZiBQbGFuIG5vZGVzIHRoYXQgY291bGQgY29udGFpbiBBZ2dyZWZzIGRvIG5vdCBo YXZlIGFueSBvZiB0aGUKcmVzY2FuIG9wdGltaXphdGlvbnMgdGhhdCBhcmUgY29udHJvbGxlZCBi eSBleHRQYXJhbS9hbGxQYXJhbS4KTm9uZXRoZWxlc3MgaXQgc2VlbXMgY2VydGFpbiB0byBiaXRl IHVzIHNvbWVkYXksIHNvIGxldCdzIGZpeCBpdAppbiBhIHNlbGYtY29udGFpbmVkIHBhdGNoIHRo YXQgY2FuIGJlIGJhY2stcGF0Y2hlZCBpZiB3ZSBmaW5kIGEKY2FzZSBpbiB3aGljaCB0aGVyZSdz IGEgbGl2ZSBidWcgcHJlLXYxNy4KClRoZSBjbGVhbmVzdCBmaXggd291bGQgYmUgdG8gcGVyZm9y bSBhIHNlcGFyYXRlIHRyZWUgd2FsayB0byBkbwp0aGVzZSBzdWJzdGl0dXRpb25zIGJlZm9yZSBT U19maW5hbGl6ZV9wbGFuIHJ1bnMuICBUaGF0IHNlZW1zCnVuYXR0cmFjdGl2ZSwgZmlyc3QgYmVj YXVzZSBhIHdob2xlLXRyZWUgbXV0YXRpb24gcGFzcyBpcyBleHBlbnNpdmUsCmFuZCBzZWNvbmQg YmVjYXVzZSB3ZSBsYWNrIGluZnJhc3RydWN0dXJlIGZvciB2aXNpdGluZyBleHByZXNzaW9uCnN1 YnRyZWVzIGluIGEgUGxhbiB0cmVlLCBzbyB0aGF0IHdlJ2QgbmVlZCBhIG5ldyBmdW5jdGlvbiBr bm93aW5nCmFzIG11Y2ggYXMgU1NfZmluYWxpemVfcGxhbiBrbm93cyBhYm91dCB0aGF0LiAgSSBh bHNvIGNvbnNpZGVyZWQKc3dhcHBpbmcgdGhlIG9yZGVyIG9mIFNTX2ZpbmFsaXplX3BsYW4gYW5k IHNldF9wbGFuX3JlZmVyZW5jZXMsCmJ1dCB0aGF0IGZlbGwgZm91bCBvZiB2YXJpb3VzIGFzc3Vt cHRpb25zIHRoYXQgc2VlbSB0cmlja3kgdG8gZml4LgpTbyB0aGUgYXBwcm9hY2ggYWRvcHRlZCBo ZXJlIGlzIHRvIHRlYWNoIFNTX2ZpbmFsaXplX3BsYW4gaXRzZWxmCnRvIGNoZWNrIGZvciBzdWNo IEFnZ3JlZnMuICBJIHJlZmFjdG9yZWQgdGhpbmdzIGEgYml0IGluIHNldHJlZnMuYwp0byBhdm9p ZCBoYXZpbmcgdGhyZWUgY29waWVzIG9mIHRoZSBjb2RlIHRoYXQgZG9lcyB0aGF0LgoKR2l2ZW4g dGhlIGxhY2sgb2YgYW55IGN1cnJlbnRseS1rbm93biBidWcsIG5vIHRlc3QgY2FzZSBoZXJlLgoK RGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMzkxODgwLjE2ODkwMjUwMDNAc3NzLnBn aC5wYS51cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2QwZDQ0MDQ5ZDEyNjJhZWQyZWVlOTA2ZDI2 YWY4NTI5NDgyMDZkYjAKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5k L29wdGltaXplci9wbGFuL3NldHJlZnMuYyAgIHwgNjggKysrKysrKysrKysrKysrKysrKysrLS0t LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9zdWJzZWxlY3QuYyB8IDI1ICsr KysrKysrKysrLS0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL3BsYW5tYWluLmggICAgICAgfCAgMiAr CjMgZmlsZXMgY2hhbmdlZCwgNjYgaW5zZXJ0aW9ucygrKSwgMjkgZGVsZXRpb25zKC0pCgo= --===============1088968998994303029==--