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 1sqZr5-00AuBS-7R for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 15:11:04 +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 1sqZr4-00CFlM-RM for pgsql-committers@arkaria.postgresql.org; Tue, 17 Sep 2024 15:11:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqZr4-00CFem-JT for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:11:02 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqZqy-001fPL-W1 for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:11:01 +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-005LiX-6R 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-001WYd-Qh for pgsql-committers@lists.postgresql.org; Tue, 17 Sep 2024 15:10:55 +0000 Content-Type: multipart/mixed; boundary="===============0368627386167917356==" 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 --===============0368627386167917356== 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 ZWQuCgpCcmFuY2gKLS0tLS0tClJFTF8xN19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczov L2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2EyNGJmZmMwMjFkOTlhNzgwOWRhMzZi NzRiODg3M2VmMDdiOTJlYzAKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNr ZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0cmVlLmMgfCA1MyArKysrKysrKysrKysrKysrKysrKysrKyst LS0tLS0tLS0tLS0tLQoxIGZpbGUgY2hhbmdlZCwgMzMgaW5zZXJ0aW9ucygrKSwgMjAgZGVsZXRp b25zKC0pCgo= --===============0368627386167917356==--