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 1nuM8n-0001Hr-Fs for pgsql-committers@arkaria.postgresql.org; Thu, 26 May 2022 22:39:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nuM8l-00053p-Lh for pgsql-committers@arkaria.postgresql.org; Thu, 26 May 2022 22:39:35 +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 1nuM8l-00052R-3W for pgsql-committers@lists.postgresql.org; Thu, 26 May 2022 22:39:35 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nuM8h-00071Q-0r for pgsql-committers@lists.postgresql.org; Thu, 26 May 2022 22:39:33 +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=twFUpkG212QbRW/sPqB+5Xjm9LDu0oxc1ZZJPxNq4fg=; b=Rs5RdRMxVdKNz0/8kOQiDRsKX6 v+QrSc24mwdnpS7PUhZB4+vjAI4UjHQeX7e+CSivO36JXJ02BzuCqnG+lVX2ORw0618GD1RZqlANC X/YviiZYQg4tvic6jRPQeaUEaiWVYoy6iLZLKcNOEu10V+PUgloSw7Vzyn8Pw4hniaxcmsRs+1t1v l3QBhFUKWsCxS7ExWJIY4rHrOqn+FCSJgpzFYZ/XTHz2cTrO+8majYzj0e6ovAm/lKWAaI2tCWVNj UyABsKQaoVzpr0k7ymsPobdVGldlizctUKIfP4Ex8UoymeyAV85lxlK8NHGU4hfNiSI4JiX1UUR/y K2OljtcA==; 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 1nuM8g-0003uj-EI for pgsql-committers@lists.postgresql.org; Thu, 26 May 2022 22:39:30 +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 1nuM8f-001IRF-07 for pgsql-committers@lists.postgresql.org; Thu, 26 May 2022 22:39:29 +0000 Content-Type: multipart/mixed; boundary="===============1676890319808778197==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Teach remove_unused_subquery_outputs about window run conditions X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 26 May 2022 22:39:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1676890319808778197== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGVhY2ggcmVtb3ZlX3VudXNlZF9zdWJxdWVyeV9vdXRwdXRzIGFib3V0IHdpbmRvdyBydW4gY29u ZGl0aW9ucwoKOWQ5YzAyY2NkIGFkZGVkIGNvZGUgdG8gYWxsb3cgdGhlIGV4ZWN1dG9yIHRvIHRh a2Ugc2hvcnRjdXRzIHdoZW4gcXVhbHMKb24gbW9ub3RvbmljIHdpbmRvdyBmdW5jdGlvbnMgZ3Vh cmFudGVlZCB0aGF0IG9uY2UgdGhlIHF1YWwgYmVjYW1lIGZhbHNlCml0IGNvdWxkIG5ldmVyIGJl Y29tZSB0cnVlIGFnYWluLiAgV2hlbiBwb3NzaWJsZSwgYmFzZXJlc3RyaWN0aW5mbyBxdWFscwph cmUgY29udmVydGVkIHRvIGJlY29tZSB0aGVzZSBxdWFscywgd2hpY2ggd2UgY2FsbCBydW4gY29u ZGl0aW9ucy4KClVuZm9ydHVuYXRlbHksIGluIDlkOWMwMmNjZCwgSSBmb3Jnb3QgdG8gdXBkYXRl CnJlbW92ZV91bnVzZWRfc3VicXVlcnlfb3V0cHV0cyB0byB0ZWFjaCBpdCBhYm91dCB0aGVzZSBy dW4gY29uZGl0aW9ucy4KVGhpcyBjb3VsZCBjYXVzZSBhIFdpbmRvd0Z1bmMgY29sdW1uIHdoaWNo IHdhcyB1bnVzZWQgaW4gdGhlIHRhcmdldCBsaXN0CmJ1dCByZWZlcmVuY2VkIGJ5IGFuIHVwcGVy LWxldmVsIFdIRVJFIGNsYXVzZSB0byBiZSByZW1vdmVkIGZyb20gdGhlCnN1YnF1ZXJ5IHdoZW4g dGhlIHF1YWwgaW4gdGhlIFdIRVJFIGNsYXVzZSB3YXMgY29udmVydGVkIGludG8gYSB3aW5kb3cg cnVuCmNvbmRpdGlvbi4gIEJlY2F1c2Ugb2YgdGhpcywgdGhlIGVudGlyZSBXaW5kb3dDbGF1c2Ug d291bGQgYmUgcmVtb3ZlZCBmcm9tCnRoZSBxdWVyeSByZXN1bHRpbmcgaW4gYWRkaXRpb25hbCBy b3dzIG1ha2luZyBpdCBpbnRvIHRoZSByZXN1bHRzZXQgd2hlbgp0aGV5IHNob3VsZCBoYXZlIGJl ZW4gZmlsdGVyZWQgb3V0IGJ5IHRoZSBXSEVSRSBjbGF1c2UuCgpIZXJlIHdlIGZpeCB0aGlzIGJ5 IHJlY29yZGluZyB3aGljaCB0YXJnZXQgbGlzdCBpdGVtcyBpbiB0aGUgc3VicXVlcnkgaGF2ZQpy dW4gY29uZGl0aW9ucy4gVGhhdCBnZXRzIHBhc3NlZCBhbG9uZyB0byByZW1vdmVfdW51c2VkX3N1 YnF1ZXJ5X291dHB1dHMKdG8gdGVsbCBpdCBub3QgdG8gcmVtb3ZlIHRoZXNlIGl0ZW1zIGZyb20g dGhlIHRhcmdldCBsaXN0LgoKQnVnOiAjMTc0OTUKUmVwb3J0ZWQtYnk6IEplcmVteSBFdmFucwpS ZXZpZXdlZC1ieTogUmljaGFyZCBHdW8KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8x NzQ5NS03ZmZlMmZhMGIyNjFiOWZhQHBvc3RncmVzcWwub3JnCgpCcmFuY2gKLS0tLS0tCm1hc3Rl cgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRp ZmYvM2U5YWJkMmViMWIxZjY4NjMyNTBmMDYwMjkwZjUxNGYzMGNlODA0NAoKTW9kaWZpZWQgRmls ZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvYWxscGF0aHMuYyB8 IDUwICsrKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tCnNyYy9iYWNrZW5kL3BhcnNl ci9wYXJzZV9jbGF1c2UuYyAgICAgfCAgMSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvd2lu ZG93Lm91dCAgfCAxOSArKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3dpbmRvdy5z cWwgICAgICAgfCAxMCArKysrKysrCjQgZmlsZXMgY2hhbmdlZCwgNjkgaW5zZXJ0aW9ucygrKSwg MTEgZGVsZXRpb25zKC0pCgo= --===============1676890319808778197==--