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 1pf2ol-0004lm-BN for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Mar 2023 18:04:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pf2oj-0005mK-W0 for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Mar 2023 18:04:09 +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 1pf2UN-0002yC-Ne for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 17:43:08 +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 1pf2UL-00073g-Et for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 17:43:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=23aUDpYbX46fBUJGBrpvoXso50boCJpYvlpnh0vNyJs=; b=KIiQfIQqRm/A8l8apMeLhXvwYF 6LOqbmxou447Kn19KqIppBnAEiTu95xHdwcAZodDcGtNn2KAtPdracquFNBKQKwyfvNUMwsIAFnsT l8yI0aX9FgM1B3vbjC56LFw8+7CfkN0ZxrD9bEIQHgXiw1vTfJoq2mx48BtMLFymFr91IG7DcxmXK ybasNKwJkokf0jeY9HTfqKErqfsel0TgO5m3i6rioY5tj/CG6830wx0gDb6bvl6XRkrW15EA2Jalm Kt3ZNhQut0z7opiudR4pMm9ADARCwSza93Bu3xjc4vvjcrrK3clm8sn3K+hOKbiOpZhG/auFhnFdh trSzdw3A==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pf2UK-0002Dx-4r for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 17:43:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pf2UH-00Gtz8-Fb for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 17:43:02 +0000 Content-Type: multipart/mixed; boundary="===============2807133715967091747==" MIME-Version: 1.0 Subject: BUG #17862: Overall query cost ignores window function To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tim3sp@gmail.com Reply-To: tim3sp@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 22 Mar 2023 17:42:03 +0000 Message-ID: <17862-1ab8f74b0f7b0611@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2807133715967091747== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg2MgpMb2dnZWQgYnk6ICAgICAgICAgIFRpbSBQYWxtZXIKRW1haWwg YWRkcmVzczogICAgICB0aW0zc3BAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTUuMgpP cGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbgpEZXNjcmlwdGlvbjogICAgICAgIAoKVGhpcyBxdWVy eSBuZWVkcyB0byByZWFkIGFsbCBvZiBsYXJnZV90YWJsZSB0byBjb3VudCB0aGUgbnVtYmVyIG9m IHJvd3MsCmRlc3BpdGUgdGhlIExJTUlUIGNsYXVzZToNCg0KICAgIFNFTEVDVCBsYXJnZV90YWJs ZS4qLCBjb3VudCgqKSBPVkVSICgpDQogICAgRlJPTSBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAw MDAwMDAwMCkgbGFyZ2VfdGFibGUNCiAgICBMSU1JVCAxMA0KDQpJIHdvdWxkIGhhdmUgZXhwZWN0 ZWQgYSBxdWVyeSBwbGFuIHNvbWV0aGluZyBsaWtlIHRoaXMsIHdpdGggYSBsYXJnZSBvdmVyYWxs CmNvc3Q6DQoNCiBMaW1pdCAgKGNvc3Q9MC4wMC4uMjI1MDAwMDAwMDAuMDAgcm93cz0xMCB3aWR0 aD0xNikNCiAgIC0+ICBXaW5kb3dBZ2cgIChjb3N0PTAuMDAuLjIyNTAwMDAwMDAwLjAwIHJvd3M9 MTAwMDAwMDAwMDAwMCB3aWR0aD0xNikNCiAgICAgICAgIC0+ICBGdW5jdGlvbiBTY2FuIG9uIGdl bmVyYXRlX3NlcmllcyBsYXJnZV90YWJsZSAKKGNvc3Q9MC4wMC4uMTAwMDAwMDAwMDAuMDAgcm93 cz0xMDAwMDAwMDAwMDAwIHdpZHRoPTgpDQoNCkJ1dCBJIGFjdHVhbGx5IGdldCB0aGlzIHF1ZXJ5 IHBsYW4sIHdpdGggYSBjb3N0IG9mIDAuMjM6DQoNCiBMaW1pdCAgKGNvc3Q9MC4wMC4uMC4yMyBy b3dzPTEwIHdpZHRoPTE2KQ0KICAgLT4gIFdpbmRvd0FnZyAgKGNvc3Q9MC4wMC4uMjI1MDAwMDAw MDAuMDAgcm93cz0xMDAwMDAwMDAwMDAwIHdpZHRoPTE2KQ0KICAgICAgICAgLT4gIEZ1bmN0aW9u IFNjYW4gb24gZ2VuZXJhdGVfc2VyaWVzIGxhcmdlX3RhYmxlIAooY29zdD0wLjAwLi4xMDAwMDAw MDAwMC4wMCByb3dzPTEwMDAwMDAwMDAwMDAgd2lkdGg9OCkNCg0KSSBiZWxpZXZlIHRoaXMgKG9u IGEgbW9yZSBjb21wbGljYXRlZCBxdWVyeSkgaXMgYWZmZWN0aW5nIHRoZSBwbGFuIGNob3NlbiBi eQp0aGUgb3B0aW1pemVyLgoK --===============2807133715967091747==--