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 1qyTV8-008gh2-B3 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Nov 2023 08:56:31 +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 1qyTV6-00C9sj-UV for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Nov 2023 08:56:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyKEu-009VKl-LN for pgsql-bugs@lists.postgresql.org; Wed, 01 Nov 2023 23:03:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qyKEr-003Vtu-1p for pgsql-bugs@lists.postgresql.org; Wed, 01 Nov 2023 23:03: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=a3JnddhBa3uEO5gz0YEps8dfIy3xsiH0nuoAHjp0paA=; b=IC4WtOXKkJkRbSt8TMl3LQHx/T Xpu/GoJT6t9gWm+ym3HnnURmX35sRrh5NOGXvw4wQbfmw/zF+JpuWU79fJz66gQ7/ObTBIhcJ1g6H j9H1pavC52SWcrvdhB+OQoDtePMZnLgON/Hy7YKFGeoyJ62nSzCjEx4cNwTEk6E95T47IIP29De+E 29C3cMrFlemWHYqgK9ibMUfJ4EAlFuPFd7wQRkqX8/u/TVRZ020/sLrRDfgWoqIz6lIVEHLYFuiO6 DGqkt3zm90KJLQH7woEoUAeOrKJ4fmJ12vji1+IGuuNNQa2kupfGueG5l6ouVLq0YunQFuwKJpvj+ lTauJliQ==; 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 1qyKEq-0001rg-9Q for pgsql-bugs@lists.postgresql.org; Wed, 01 Nov 2023 23:03: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 1qyKEn-00D6dh-Bn for pgsql-bugs@lists.postgresql.org; Wed, 01 Nov 2023 23:03:02 +0000 Content-Type: multipart/mixed; boundary="===============1577517182641073050==" MIME-Version: 1.0 Subject: BUG #18177: certain queries under certain contexts take multiple orders of magnitude longer compared to v10 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: rleach@princeton.edu Reply-To: rleach@princeton.edu, pgsql-bugs@lists.postgresql.org Date: Wed, 01 Nov 2023 23:02:21 +0000 Message-ID: <18177-a282c2eaaf791f21@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 --===============1577517182641073050== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE3NwpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmVydCBMZWFjaApFbWFp bCBhZGRyZXNzOiAgICAgIHJsZWFjaEBwcmluY2V0b24uZWR1ClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMTIKT3BlcmF0aW5nIHN5c3RlbTogICBtYWNPUyBhbmQgbGludXgKRGVzY3JpcHRpb246ICAg ICAgICAKCldlIHVwZ3JhZGVkIG91ciBEamFuZ28gb24gYSBsYXJnZSBwcm9qZWN0IGZyb20gMy4y IHRvIDQuMiAoYW5kIHBvc3RncmVzIGZyb20KMTAgdG8gMTMpIGFuZCBmb3VuZCB0aGF0IG91ciB0 ZXN0IHN1aXRlIHdoaWNoIHR5cGljYWxseSB0b29rIGFib3V0IDI1LTMwCm1pbnV0ZXMgcm91Z2hs eSBkb3VibGVkIGluIHJ1bm5pbmcgdGltZSAoNTAgdG8gNzUgbWludXRlcykuICBTd2l0Y2hpbmcg YmFjawp0byBEamFuZ28gMy4yIGJ1dCBrZWVwaW5nIHBvc3RncmVzIDEzIGFsc28gZXhwZXJpZW5j ZXMgdGhlIHNhbWUgc2xvdy1kb3duLiAKSSBpc29sYXRlZCBvbmUgdGVzdCB0aGF0IG5vcm1hbGx5 IHRvb2sgOTBzIHRoYXQgbm93IHRha2VzIGNvbnNpc3RlbnRseSA0MDBzCmFuZCBmdXJ0aGVyIG5h cnJvd2VkIGl0IGRvd24gdG8gYSBzaW5nbGUgKHNpbXBsZSkgcXVlcnkuICBUaGF0IHRlc3Qgd291 bGQKcnVuIGZhc3QgaWYgcnVuIGJ5IGl0c2VsZiwgYnV0IGl0IHJ1biBhZnRlciBhIHNlcmllcyBv ZiBvdGhlciB0ZXN0cywgd291bGQKdGFrZSA0MDBzLg0KDQpJIGV4dHJhY3RlZCB0aGUgU1FMIGdl bmVyYXRlZCBmb3IgdGhlIHF1ZXJ5IGFuZCBwZXJmb3JtZWQgYW4gYGV4cGxhaW5gIG9uCml0LCBh bmQgaXQgc2hvd2VkIHRoYXQgdGhlIGFjdHVhbCB0aW1lIHRvb2sgd2F5IGxvbmdlciB0aGFuIHRo ZSBlc3RpbWF0ZWQKY29zdC4gIERvaW5nIGEgdmFjdXVtIGZ1bGwgYW5hbHl6ZSB3YXMgYWJsZSB0 byByZXN0b3JlIHRoZSBzcGVlZCwgYnV0IHRoZQpvbmx5IHBsYWNlIHdoZXJlIEkgd2FzIGFibGUg dG8gdXNlIGl0IHRvIGdldCB0aGUgc3BlZWQgYmFjaywgcmVsYXRpdmVseQpjYXVzZWQgd2VpcmQg ZXJyb3JzIGluIG90aGVyIHRlc3RzLg0KDQpJIGNhbm5vdCBjbGFpbSB0byB1bmRlcnN0YW5kIHRo ZSBidWcgdGhhdCBpcyBjYXVzaW5nIHRoaXMgaXNzdWUsIHNvIHRoZSBiZXN0CkkgY2FuIGRvIGlz IHNpbXBseSBwcm92aWRlIHRoZSBleHBsYWluIG91dHB1dCBhbmQgdHJ5IHRvIGtlZXAgZnJvbSBw cm92aWRpbmcKY29uZnVzaW5nIGRldGFpbHMsIGJlY2F1c2UgdGhpcyBpcyBvdXRzaWRlIHRoZSBy ZWFsbSBvZiBteSBleHBlcnRpc2U6DQoNCmBgYA0KKCdBZ2dyZWdhdGUgIChjb3N0PTQ1Ljc3Li40 NS43OCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTIwMjMyNi4yMTAuLjIwMjMyNi4yMTQg cm93cz0xIGxvb3BzPTEpJywpDQooJyAgLT4gIFVuaXF1ZSAgKGNvc3Q9MC44OC4uNDUuNzYgcm93 cz0xIHdpZHRoPTEwNTIpIChhY3R1YWwKdGltZT0xMDQ5Mi45NjMuLjIwMjMyNi4yMDUgcm93cz0x IGxvb3BzPTEpJywpDQooJyAgICAgICAgLT4gIE5lc3RlZCBMb29wICAoY29zdD0wLjg4Li40NS43 NSByb3dzPTEgd2lkdGg9MTA1MikgKGFjdHVhbAp0aW1lPTEwNDkyLjk1OS4uMjAyMzI2LjE4OCBy b3dzPTggbG9vcHM9MSknLCkNCignICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCJEYXRhUmVw b19wZWFrZGF0YSIuaWQgPQoiRGF0YVJlcG9fcGVha2RhdGFsYWJlbCIucGVha19kYXRhX2lkKScs KQ0KKCcgICAgICAgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBKb2luIEZpbHRlcjogMzA3NicsKQ0K KCcgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC42Mi4uMzcuNDcgcm93cz0x IHdpZHRoPTgpIChhY3R1YWwKdGltZT0xMDQ5Mi40NTUuLjIwMjMyMy45MzUgcm93cz04IGxvb3Bz PTEpJywpDQooJyAgICAgICAgICAgICAgICAgICAgSm9pbiBGaWx0ZXI6ICgiRGF0YVJlcG9fcGVh a2dyb3VwIi5pZCA9CiJEYXRhUmVwb19wZWFrZGF0YSIucGVha19ncm91cF9pZCknLCkNCignICAg ICAgICAgICAgICAgICAgICBSb3dzIFJlbW92ZWQgYnkgSm9pbiBGaWx0ZXI6IDc4ODgnLCkNCign ICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZwoiRGF0YVJlcG9fcGVha2Rh dGFfcGVha19ncm91cF9pZF80ZGQ4N2Y0YSIgb24gIkRhdGFSZXBvX3BlYWtkYXRhIiAKKGNvc3Q9 MC4yNS4uOC4yNiByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDE3Li43LjE0OSByb3dz PTc4OTYKbG9vcHM9MSknLCkNCignICAgICAgICAgICAgICAgICAgICAtPiAgTmVzdGVkIExvb3Ag IChjb3N0PTAuMzguLjI5LjIwIHJvd3M9MSB3aWR0aD00KQooYWN0dWFsIHRpbWU9Mi45NDIuLjI1 LjYyMSByb3dzPTEgbG9vcHM9Nzg5NiknLCkNCignICAgICAgICAgICAgICAgICAgICAgICAgICBK b2luIEZpbHRlcjoKKCJEYXRhUmVwb19wZWFrZ3JvdXAiLnBlYWtfYW5ub3RhdGlvbl9maWxlX2lk ID0KIkRhdGFSZXBvX2FyY2hpdmVmaWxlIi5pZCknLCkNCignICAgICAgICAgICAgICAgICAgICAg ICAgICAtPiAgTmVzdGVkIExvb3AgIChjb3N0PTAuMzguLjE4LjQzIHJvd3M9MQp3aWR0aD04KSAo YWN0dWFsIHRpbWU9Mi45MzUuLjI1LjYxNCByb3dzPTEgbG9vcHM9Nzg5NiknLCkNCignICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBKb2luIEZpbHRlcjogKCJEYXRhUmVwb19tc3J1biIu c2FtcGxlX2lkID0KIkRhdGFSZXBvX3NhbXBsZSIuaWQpJywpDQooJyAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEpvaW4gRmlsdGVyOiA4MycsKQ0KKCcgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBOZXN0ZWQgTG9vcCAgKGNvc3Q9MC4xMi4u MTAuMTUgcm93cz0xCndpZHRoPTEyKSAoYWN0dWFsIHRpbWU9MC4wMjguLjIuNTEzIHJvd3M9ODQg bG9vcHM9Nzg5NiknLCkNCignICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBK b2luIEZpbHRlcjoKKCJEYXRhUmVwb19wZWFrZ3JvdXAiLm1zcnVuX2lkID0gIkRhdGFSZXBvX21z cnVuIi5pZCknLCkNCignICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBSb3dz IFJlbW92ZWQgYnkgSm9pbiBGaWx0ZXI6CjM0ODYnLCkNCignICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZwoiRGF0YVJlcG9fcGVha2dyb3Vw X3BlYWtfYW5ub3RhdGlvbl9maWxlX2lkXzZkYzJmYzI1IiBvbgoiRGF0YVJlcG9fcGVha2dyb3Vw IiAgKGNvc3Q9MC4xMi4uOC4xNCByb3dzPTEgd2lkdGg9MTIpIChhY3R1YWwKdGltZT0wLjAwNi4u MC40NjQgcm93cz04NCBsb29wcz03ODk2KScsKQ0KKCIgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKChuYW1lKTo6dGV4dCA9CidzZXJpbmUnOjp0ZXh0 KSIsKQ0KKCcgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFJvd3Mg UmVtb3ZlZCBieSBGaWx0ZXI6CjEwMDgnLCkNCignICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gIkRhdGFSZXBvX21zcnVuIiAKKGNvc3Q9MC4wMC4u Mi4wMCByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDEzLi4wLjAxNyByb3dzPTQyCmxv b3BzPTY2MzI2NCknLCkNCignICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgSW5k ZXggU2NhbiB1c2luZwoiRGF0YVJlcG9fc2FtcGxlX3BrZXkiIG9uICJEYXRhUmVwb19zYW1wbGUi ICAoY29zdD0wLjI1Li44LjI3IHJvd3M9MQp3aWR0aD00KSAoYWN0dWFsIHRpbWU9MC4xOTQuLjAu Mjc1IHJvd3M9MSBsb29wcz02NjMyNjQpJywpDQooIiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgRmlsdGVyOiAoKG5hbWUpOjp0ZXh0ID0KJ3h6bDVfcGFuYyc6OnRleHQpIiwp DQooJyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5 IEZpbHRlcjogMjgxJywpDQooJyAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2Fu IG9uICJEYXRhUmVwb19hcmNoaXZlZmlsZSIgCihjb3N0PTAuMDAuLjEwLjc1IHJvd3M9MSB3aWR0 aD00KSAoYWN0dWFsIHRpbWU9MC4wMDIuLjAuMDAyIHJvd3M9MQpsb29wcz03ODk2KScsKQ0KKCIg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZpbHRlcjogKChmaWxlbmFtZSk6OnRleHQg PQonYWxhZmFzdGVkX2Nvci54bHN4Jzo6dGV4dCkiLCkNCignICAgICAgICAgICAgICAtPiAgSW5k ZXggU2NhbiB1c2luZwoiRGF0YVJlcG9fcGVha2RhdGFsYWJlbF9wZWFrX2RhdGFfaWRfZjYxNTFk NGEiIG9uICJEYXRhUmVwb19wZWFrZGF0YWxhYmVsIiAKKGNvc3Q9MC4yNS4uOC4yNyByb3dzPTEg d2lkdGg9MTIpIChhY3R1YWwgdGltZT0wLjAwNy4uMC4yMTcgcm93cz0zODYKbG9vcHM9OCknLCkN CigiICAgICAgICAgICAgICAgICAgICBGaWx0ZXI6ICgoZWxlbWVudCk6OnRleHQgPSAnQyc6OnRl eHQpIiwpDQooJyAgICAgICAgICAgICAgICAgICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTgw JywpDQooJ1BsYW5uaW5nIFRpbWU6IDAuOTYzIG1zJywpDQooJ0V4ZWN1dGlvbiBUaW1lOiAyMDIz MjcuMzM0IG1zJywpDQpgYGANCg0KVGhlcmUgaXMgYSB0aHJlYWQgb24gdGhlIERqYW5nbyBmb3J1 bSB3aXRoIGxvdHMgb2Ygb3RoZXIgZGV0YWlscywgYnV0IGF0IHRoZQpvdXRzZXQgb2YgdGhhdCBk aXNjdXNzaW9uLCBJIGRpZG4ndCBldmVuIGtub3cgd2hhdCB3YXMgY2F1c2luZyB0aGUgc3BlZWQK aXNzdWUuICBGb3IgYWxsIEkga25ldywgaXQgd2FzIHNvbWUgb3RoZXIgY2hhbmdlIHRvIG91ciBj b2RlLCBidXQgd2l0aCB0aGUKaGVscCBvZiB0aGUgZm9sa3MgaW4gdGhlIERqYW5nbyBmb3J1bSwg SSB0aGluayB0aGF0IHRoaXMgaXMgY29uY2x1c2l2ZWx5IGR1ZQp0byBwb3N0Z3JlcyAxMy4NCg0K aHR0cHM6Ly9mb3J1bS5kamFuZ29wcm9qZWN0LmNvbS90L3Rlc3QtdGltZS1kb3VibGVkLWFmdGVy LWRqYW5nby0zLTItNC0yLWFuZC1wb3N0Z3Jlcy0xMC0xMy11cGRhdGUvMjQ4NDMvMTYNCg0KSWYg dGhpcyBpcyBhIGtub3duIGlzc3VlLCBpcyB0aGVyZSBhIHZlcnNpb24gb2YgcG9zdGdyZXMgKGFm dGVyIHYxMykgdGhhdApyZXNvbHZlcyBpdD8KCg== --===============1577517182641073050==--