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 1pLF7B-0008UX-OU for pgsql-committers@arkaria.postgresql.org; Fri, 27 Jan 2023 03:09:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pLF7A-0000ys-3E for pgsql-committers@arkaria.postgresql.org; Fri, 27 Jan 2023 03:09:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLF79-0000yf-F6 for pgsql-committers@lists.postgresql.org; Fri, 27 Jan 2023 03:09:19 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pLF75-0001zU-Vx for pgsql-committers@lists.postgresql.org; Fri, 27 Jan 2023 03:09:19 +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=v6IySmj/5CY/2bfI9851Ax9JGk0PNwcO1mdQhwPArr4=; b=GGjvw1Tz+2y8AruOe0w5cNGzpj Zmag+jWkZ5fLAL+dyOVvAhtCbl9sjyYntVvaxea3og3GFxML+695R32VOIr84k93Edaq2zW8bQzfd spfDPl0raS/CP0kbHKdxTnrk18fyje1iA/EvjsZ5xOVx/PwSWfMvbvWQowFbbb3LVNEA15n4y4E5E Cs+MAq2Gs1DNvIMfiAOpqiLCwICA3MDMF+rskMUAtNI3y0qJ9X5bhkIsu7OmVCjGvpUsLt1Y0g3BD d42Sq1l5IX459j4cLuDtIpGuYg3RMrZ7Bhw4PClAweoC4uqOjt1I3ay484hmQTq+Enp/DyY9tE2gB guOZEMMA==; 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 1pLF74-0005CC-ML for pgsql-committers@lists.postgresql.org; Fri, 27 Jan 2023 03:09:14 +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 1pLF72-0007Dl-O6 for pgsql-committers@lists.postgresql.org; Fri, 27 Jan 2023 03:09:14 +0000 Content-Type: multipart/mixed; boundary="===============4666116592789947273==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Teach planner about more monotonic window functions X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 27 Jan 2023 03:09:14 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4666116592789947273== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGVhY2ggcGxhbm5lciBhYm91dCBtb3JlIG1vbm90b25pYyB3aW5kb3cgZnVuY3Rpb25zCgo5ZDlj MDJjY2QgaW50cm9kdWNlZCBydW5Db25kaXRpb25zIGZvciB3aW5kb3cgZnVuY3Rpb25zIHRvIGFs bG93Cm1vbm90b25pYyB3aW5kb3cgZnVuY3Rpb24gZXZhbHVhdGlvbiB0byBiZSBtYWRlIG1vcmUg ZWZmaWNpZW50IHdoZW4gdGhlCndpbmRvdyBmdW5jdGlvbiB2YWx1ZSB3ZW50IGJleW9uZCBzb21l IHZhbHVlIHRoYXQgaXQgd291bGQgbmV2ZXIgZ28gYmFjawpmcm9tIGR1ZSB0byBpdHMgbW9ub3Rv bmljIG5hdHVyZS4gIFRoYXQgY29tbWl0IGFkZGVkIHByb3N1cHBvcnQgZnVuY3Rpb25zCnRvIGlu Zm9ybSB0aGUgcGxhbm5lciB0aGF0IHJvd19udW1iZXIoKSwgcmFuaygpLCBkZW5zZV9yYW5rKCkg YW5kIHNvbWUKZm9ybXMgb2YgY291bnQoKikgd2VyZSBtb25vdG9uaWMuICBIZXJlIHdlIGFkZCBz dXBwb3J0IGZvciBudGlsZSgpLApjdW1lX2Rpc3QoKSBhbmQgcGVyY2VudF9yYW5rKCkuCgpSZXZp ZXdlZC1ieTogTWVsYW5pZSBQbGFnZW1hbgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9t L0NBQXBIRHZxUitWcUI4cyt4Ui0yNGJ6SmJVOHh5RnJCc3pKMTdxS2dFQ2Y3Y1d4TENhQUBtYWls LmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzQ1NmZhNjM1YTkwOWVlMzZmNzNjYTg0 ZDM0MDUyMWJkNzMwZjI2NWYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL3V0aWxzL2FkdC93aW5kb3dmdW5jcy5jICB8IDMwICsrKysrKysrKysrKysrKysrKysrKysr KysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3dpbmRvdy5vdXQgfCAyNiArKysrKysr KysrKysrKy0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC93aW5kb3cuc3FsICAgICAg fCAxMCArKysrKystLS0tCjMgZmlsZXMgY2hhbmdlZCwgNTAgaW5zZXJ0aW9ucygrKSwgMTYgZGVs ZXRpb25zKC0pCgo= --===============4666116592789947273==--