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 1sqZr4-00AuB8-1B for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 15:11:03 +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 1sqZr3-00CFQO-1W for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 15:11:01 +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 1sqZr2-00CFQG-QT for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:11:00 +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 1sqZqz-001etE-9T for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:10:59 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqZqy-005LiW-6W for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:10:56 +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 1sqZqw-001WYc-QE for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:10:55 +0000 Content-Type: multipart/mixed; boundary="===============3401064442081658878==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid parallel nbtree index scan hangs with SAOPs. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 17 Sep 2024 15:10:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3401064442081658878== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgcGFyYWxsZWwgbmJ0cmVlIGluZGV4IHNjYW4gaGFuZ3Mgd2l0aCBTQU9Qcy4KCkNvbW1p dCA1YmY3NDhiOCwgd2hpY2ggZW5oYW5jZWQgbmJ0cmVlIFNjYWxhckFycmF5T3AgZXhlY3V0aW9u LCBtYWRlCnBhcmFsbGVsIGluZGV4IHNjYW5zIHdvcmsgd2l0aCB0aGUgbmV3IGRlc2lnbiBmb3Ig YXJyYXlzIHZpYSBleHBsaWNpdApzY2hlZHVsaW5nIG9mIHByaW1pdGl2ZSBpbmRleCBzY2Fucy4g IEEgYmFja2VuZCB0aGF0IHN1Y2Nlc3NmdWxseQpzY2hlZHVsZWQgdGhlIHNjYW4ncyBuZXh0IHBy aW1pdGl2ZSBpbmRleCBzY2FuIHNhdmVkIGl0cyBiYWNrZW5kIGxvY2FsCmFycmF5IGtleXMgaW4g c2hhcmVkIG1lbW9yeS4gIEFueSBiYWNrZW5kIGNvdWxkIHBpY2sgdXAgdGhlIHNjaGVkdWxlZApw cmltaXRpdmUgc2NhbiB3aXRoaW4gX2J0X2ZpcnN0LiAgVGhpcyBzY2hlbWUgZGVjb3VwbGVzIHNj aGVkdWxpbmcgYQpwcmltaXRpdmUgc2NhbiBmcm9tIHN0YXJ0aW5nIHRoZSBzY2FuIChieSBwZXJm b3JtaW5nIGFub3RoZXIgZGVzY2VudCBvZgp0aGUgaW5kZXggdmlhIGEgX2J0X3NlYXJjaCBjYWxs IGZyb20gX2J0X2ZpcnN0KSB0byBtYWtlIHRoaW5ncyByb2J1c3QuCgpUaGUgc2NoZW1lIGhhZCBh IGRlYWRsb2NrIGhhemFyZCwgYXQgbGVhc3Qgd2hlbiB0aGUgbGVhZGVyIHByb2Nlc3MKcGFydGlj aXBhdGVkIGluIHRoZSBzY2FuLiAgX2J0X3BhcmFsbGVsX3NlaXplIGhhZCBhIGNvZGUgcGF0aCB0 aGF0IG1hZGUKYmFja2VuZHMgdGhhdCB3ZXJlIG5vdCBpbiBhbiBpbW1lZGlhdGUgcG9zaXRpb24g dG8gc3RhcnQgYSBzY2hlZHVsZWQKcHJpbWl0aXZlIGluZGV4IHNjYW4gd2FpdCBmb3Igc29tZSBv dGhlciBiYWNrZW5kIHRvIGRvIHNvIGluc3RlYWQuClVuZGVyIHRoZSByaWdodCBjaXJjdW1zdGFu Y2VzLCB0aGUgbGVhZGVyIHByb2Nlc3MgY291bGQgd2FpdCBoZXJlCmZvcmV2ZXI6IHRoZSBsZWFk ZXIgd291bGQgd2FpdCBmb3IgYW55IG90aGVyIGJhY2tlbmQgdG8gc3RhcnQgdGhlCnByaW1pdGl2 ZSBzY2FuLCB3aGlsZSBldmVyeSB3b3JrZXIgd2FzIGJ1c3kgd2FpdGluZyBvbiB0aGUgbGVhZGVy IHRvCmNvbnN1bWUgdHVwbGVzIGZyb20gdGhlIHNjYW4ncyB0dXBsZSBxdWV1ZS4KClRvIGZpeCwg ZG9uJ3Qgd2FpdCBmb3IgYSBzY2hlZHVsZWQgcHJpbWl0aXZlIGluZGV4IHNjYW4gdG8gYmUgc3Rh cnRlZCBieQpzb21lIG90aGVyIGVsaWdpYmxlIGJhY2tlbmQgZnJvbSB3aXRoaW4gX2J0X3BhcmFs bGVsX3NlaXplICh3aGVuIHRoZQpjYWxsaW5nIGJhY2tlbmQgaXNuJ3QgaW4gYSBwb3NpdGlvbiB0 byBkbyBzbyBpdHNlbGYpLiAgUmV0dXJuIGZhbHNlCmluc3RlYWQsIHdoaWxlIHJlY29yZGluZyB0 aGF0IHRoZSBzY2FuIGhhcyBhIHNjaGVkdWxlZCBwcmltaXRpdmUgaW5kZXgKc2NhbiBpbiBiYWNr ZW5kIGxvY2FsIHN0YXRlLiAgVGhpcyBsZWF2ZXMgdGhlIGJhY2tlbmQgaW4gdGhlIHNhbWUgc3Rh dGUKYXMgdGhlIGV4aXN0aW5nIGNhc2Ugd2hlcmUgYSBiYWNrZW5kIHNjaGVkdWxlcyAob3IgdHJp ZXMgdG8gc2NoZWR1bGUpCmFub3RoZXIgcHJpbWl0aXZlIGluZGV4IHNjYW4gZnJvbSB3aXRoaW4g X2J0X2FkdmFuY2VfYXJyYXlfa2V5cywgYmVmb3JlCmNhbGxpbmcgX2J0X3BhcmFsbGVsX3NlaXpl LiAgX2J0X3BhcmFsbGVsX3NlaXplIGFscmVhZHkgaGFuZGxlcyB0aGF0CmNhc2UgYnkgcmV0dXJu aW5nIGZhbHNlIHdpdGhvdXQgd2FpdGluZywgYW5kIHdpdGhvdXQgdW5zZXR0aW5nIHRoZQpiYWNr ZW5kIGxvY2FsIHN0YXRlLiAgTGVhdmluZyB0aGUgYmFja2VuZCBpbiB0aGlzIHN0YXRlIGVuYWJs ZXMgaXQgdG8Kc3RhcnQgYSBwcmV2aW91c2x5IHNjaGVkdWxlZCBwcmltaXRpdmUgaW5kZXggc2Nh biBvbmNlIGl0IGdldHMgYmFjayB0bwpfYnRfZmlyc3QuCgpPdmVyc2lnaHQgaW4gY29tbWl0IDVi Zjc0OGI4LCB3aGljaCBlbmhhbmNlZCBuYnRyZWUgU2NhbGFyQXJyYXlPcApleGVjdXRpb24uCgpN YXR0aGlhcyB2YW4gZGUgTWVlbnQsIHdpdGggdHdlYWtzIGJ5IG1lLgoKQXV0aG9yOiBNYXR0aGlh cyB2YW4gZGUgTWVlbnQgPGJvZWtld3VybStwb3N0Z3Jlc0BnbWFpbC5jb20+ClJlcG9ydGVkLUJ5 OiBUb21hcyBWb25kcmEgPHRvbWFzQHZvbmRyYS5tZT4KUmV2aWV3ZWQtQnk6IFBldGVyIEdlb2do ZWdhbiA8cGdAYm93dC5pZT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQUgyLVd6 bU1HYVBhMzJ1OXhfRnZFYlBUVWtQNWU5NWk9UXhSODA1NG52Q1J5ZFAtc3dAbWFpbC5nbWFpbC5j b20KQmFja3BhdGNoOiAxNy0sIHdoZXJlIG5idHJlZSBTQU9QIGV4ZWN1dGlvbiB3YXMgZW5oYW5j ZWQuCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBv c3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZDhhZGZjMThiZWJmYjFiNjliNDU2YTAwZTY3NDUz Nzc1YTc3ZjU5NAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvYWNj ZXNzL25idHJlZS9uYnRyZWUuYyB8IDUzICsrKysrKysrKysrKysrKysrKysrKysrKy0tLS0tLS0t LS0tLS0tCjEgZmlsZSBjaGFuZ2VkLCAzMyBpbnNlcnRpb25zKCspLCAyMCBkZWxldGlvbnMoLSkK Cg== --===============3401064442081658878==--