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 1pEi3Q-00076x-NC for pgsql-committers@arkaria.postgresql.org; Mon, 09 Jan 2023 02:38:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEi3P-0001L7-HN for pgsql-committers@arkaria.postgresql.org; Mon, 09 Jan 2023 02:38:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEi3O-0001Kx-Ri for pgsql-committers@lists.postgresql.org; Mon, 09 Jan 2023 02:38:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEi3K-0006j8-45 for pgsql-committers@lists.postgresql.org; Mon, 09 Jan 2023 02:38:25 +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=QJV8/21e3uCba4hqhio9nrSybI2h2WTcfWOGFayXWB0=; b=mFRfKaw3qz+WlUd5XoYDTH9qG/ DR4FpEJppYWWJXxSM+mtZY7ZzldNlbbttqKI9z+CL6FA6lR6K+DWJumXQKGfslovAPkP6pB53aYGQ OI2l7ibDPtc95t2UQmq/XfYlpRkW7CWtP0Gk03r1uY2/a5s9nxJ7DbR2lsPtJjwOZPRFp2FTIBzf7 7jMqZBzhgaFq7xrU+XkBm+sBaeMLhSvQ6777CYo84xbzpSviDu/AvC54xU3hVpEkD1YdvlwUXDCQl wdsV2lzX4KP9GVBexO0iaTkqvv1IvM5L0iPA2ym6rBPb62GjLPJWjBvcRAg+GYl2GLiSsyaaIRcTt P/wtwlzw==; 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 1pEi3J-0004iR-My for pgsql-committers@lists.postgresql.org; Mon, 09 Jan 2023 02:38:21 +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 1pEi3I-002ji3-Lv for pgsql-committers@lists.postgresql.org; Mon, 09 Jan 2023 02:38:21 +0000 Content-Type: multipart/mixed; boundary="===============3185809040901678654==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Perform apply of large transactions by parallel workers. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 09 Jan 2023 02:38:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3185809040901678654== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UGVyZm9ybSBhcHBseSBvZiBsYXJnZSB0cmFuc2FjdGlvbnMgYnkgcGFyYWxsZWwgd29ya2Vycy4K CkN1cnJlbnRseSwgZm9yIGxhcmdlIHRyYW5zYWN0aW9ucywgdGhlIHB1Ymxpc2hlciBzZW5kcyB0 aGUgZGF0YSBpbgptdWx0aXBsZSBzdHJlYW1zIChjaGFuZ2VzIGRpdmlkZWQgaW50byBjaHVua3Mg ZGVwZW5kaW5nIHVwb24KbG9naWNhbF9kZWNvZGluZ193b3JrX21lbSksIGFuZCB0aGVuIG9uIHRo ZSBzdWJzY3JpYmVyLXNpZGUsIHRoZSBhcHBseQp3b3JrZXIgd3JpdGVzIHRoZSBjaGFuZ2VzIGlu dG8gdGVtcG9yYXJ5IGZpbGVzIGFuZCBvbmNlIGl0IHJlY2VpdmVzIHRoZQpjb21taXQsIGl0IHJl YWRzIGZyb20gdGhvc2UgZmlsZXMgYW5kIGFwcGxpZXMgdGhlIGVudGlyZSB0cmFuc2FjdGlvbi4g VG8KaW1wcm92ZSB0aGUgcGVyZm9ybWFuY2Ugb2Ygc3VjaCB0cmFuc2FjdGlvbnMsIHdlIGNhbiBp bnN0ZWFkIGFsbG93IHRoZW0gdG8KYmUgYXBwbGllZCB2aWEgcGFyYWxsZWwgd29ya2Vycy4KCklu IHRoaXMgYXBwcm9hY2gsIHdlIGFzc2lnbiBhIG5ldyBwYXJhbGxlbCBhcHBseSB3b3JrZXIgKGlm IGF2YWlsYWJsZSkgYXMKc29vbiBhcyB0aGUgeGFjdCdzIGZpcnN0IHN0cmVhbSBpcyByZWNlaXZl ZCBhbmQgdGhlIGxlYWRlciBhcHBseSB3b3JrZXIKd2lsbCBzZW5kIGNoYW5nZXMgdG8gdGhpcyBu ZXcgd29ya2VyIHZpYSBzaGFyZWQgbWVtb3J5LiBUaGUgcGFyYWxsZWwgYXBwbHkKd29ya2VyIHdp bGwgZGlyZWN0bHkgYXBwbHkgdGhlIGNoYW5nZSBpbnN0ZWFkIG9mIHdyaXRpbmcgaXQgdG8gdGVt cG9yYXJ5CmZpbGVzLiBIb3dldmVyLCBpZiB0aGUgbGVhZGVyIGFwcGx5IHdvcmtlciB0aW1lcyBv dXQgd2hpbGUgYXR0ZW1wdGluZyB0bwpzZW5kIGEgbWVzc2FnZSB0byB0aGUgcGFyYWxsZWwgYXBw bHkgd29ya2VyLCBpdCB3aWxsIHN3aXRjaCB0bwoicGFydGlhbCBzZXJpYWxpemUiIG1vZGUgLSAg aW4gdGhpcyBtb2RlLCB0aGUgbGVhZGVyIHNlcmlhbGl6ZXMgYWxsCnJlbWFpbmluZyBjaGFuZ2Vz IHRvIGEgZmlsZSBhbmQgbm90aWZpZXMgdGhlIHBhcmFsbGVsIGFwcGx5IHdvcmtlcnMgdG8KcmVh ZCBhbmQgYXBwbHkgdGhlbSBhdCB0aGUgZW5kIG9mIHRoZSB0cmFuc2FjdGlvbi4gV2UgdXNlIGEg bm9uLWJsb2NraW5nCndheSB0byBzZW5kIHRoZSBtZXNzYWdlcyBmcm9tIHRoZSBsZWFkZXIgYXBw bHkgd29ya2VyIHRvIHRoZSBwYXJhbGxlbAphcHBseSB0byBhdm9pZCBkZWFkbG9ja3MuIFdlIGtl ZXAgdGhpcyBwYXJhbGxlbCBhcHBseSBhc3NpZ25lZCB0aWxsIHRoZQp0cmFuc2FjdGlvbiBjb21t aXQgaXMgcmVjZWl2ZWQgYW5kIGFsc28gd2FpdCBmb3IgdGhlIHdvcmtlciB0byBmaW5pc2ggYXQK Y29tbWl0LiBUaGlzIHByZXNlcnZlcyBjb21taXQgb3JkZXJpbmcgYW5kIGF2b2lkIHdyaXRpbmcg dG8gYW5kIHJlYWRpbmcKZnJvbSBmaWxlcyBpbiBtb3N0IGNhc2VzLiBXZSBzdGlsbCBuZWVkIHRv IHNwaWxsIGlmIHRoZXJlIGlzIG5vIHdvcmtlcgphdmFpbGFibGUuCgpUaGlzIHBhdGNoIGFsc28g ZXh0ZW5kcyB0aGUgU1VCU0NSSVBUSU9OICdzdHJlYW1pbmcnIHBhcmFtZXRlciBzbyB0aGF0IHRo ZQp1c2VyIGNhbiBjb250cm9sIHdoZXRoZXIgdG8gYXBwbHkgdGhlIHN0cmVhbWluZyB0cmFuc2Fj dGlvbiBpbiBhIHBhcmFsbGVsCmFwcGx5IHdvcmtlciBvciBzcGlsbCB0aGUgY2hhbmdlIHRvIGRp c2suIFRoZSB1c2VyIGNhbiBzZXQgdGhlIHN0cmVhbWluZwpwYXJhbWV0ZXIgdG8gJ29uL29mZics IG9yICdwYXJhbGxlbCcuIFRoZSBwYXJhbWV0ZXIgdmFsdWUgJ3BhcmFsbGVsJyBtZWFucwp0aGUg c3RyZWFtaW5nIHdpbGwgYmUgYXBwbGllZCB2aWEgYSBwYXJhbGxlbCBhcHBseSB3b3JrZXIsIGlm IGF2YWlsYWJsZS4KVGhlIHBhcmFtZXRlciB2YWx1ZSAnb24nIG1lYW5zIHRoZSBzdHJlYW1pbmcg dHJhbnNhY3Rpb24gd2lsbCBiZSBzcGlsbGVkCnRvIGRpc2suIFRoZSBkZWZhdWx0IHZhbHVlIGlz ICdvZmYnIChzYW1lIGFzIGN1cnJlbnQgYmVoYXZpb3VyKS4KCkluIGFkZGl0aW9uLCB0aGUgcGF0 Y2ggZXh0ZW5kcyB0aGUgbG9naWNhbCByZXBsaWNhdGlvbiBTVFJFQU1fQUJPUlQKbWVzc2FnZSBz byB0aGF0IGFib3J0X2xzbiBhbmQgYWJvcnRfdGltZSBjYW4gYWxzbyBiZSBzZW50IHdoaWNoIGNh biBiZQp1c2VkIHRvIHVwZGF0ZSB0aGUgcmVwbGljYXRpb24gb3JpZ2luIGluIHBhcmFsbGVsIGFw cGx5IHdvcmtlciB3aGVuIHRoZQpzdHJlYW1pbmcgdHJhbnNhY3Rpb24gaXMgYWJvcnRlZC4gQmVj YXVzZSB0aGlzIG1lc3NhZ2UgZXh0ZW5zaW9uIGlzIG5lZWRlZAp0byBzdXBwb3J0IHBhcmFsbGVs IHN0cmVhbWluZywgcGFyYWxsZWwgc3RyZWFtaW5nIGlzIG5vdCBzdXBwb3J0ZWQgZm9yCnB1Ymxp Y2F0aW9ucyBvbiBzZXJ2ZXJzIDwgUEcxNi4KCkF1dGhvcjogSG91IFpoaWppZSwgV2FuZyB3ZWks IEFtaXQgS2FwaWxhIHdpdGggZGVzaWduIGlucHV0cyBmcm9tIFNhd2FkYSBNYXNhaGlrbwpSZXZp ZXdlZC1ieTogU2F3YWRhIE1hc2FoaWtvLCBQZXRlciBTbWl0aCwgRGlsaXAgS3VtYXIsIFNoaSB5 dSwgS3Vyb2RhIEhheWF0bywgU2h2ZXRhIE1hbGxpawpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rn ci5lcy9tL0NBQTRlSzErd3lONnpwYUhVa0NMb3JFV054NzVNRzB4aE13Y0ZodmpxbTJLVVJaRUFH d0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpo dHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzIxNmE3ODQ4MjljMmM1ZjAz YWIwYzQzZTAwOTEyNmNiYjgxOWU5YjIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRv Yy9zcmMvc2dtbC9jYXRhbG9ncy5zZ21sICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAxMSAr LQpkb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAg MjggKy0KZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbCAgICAgICAgICAgICAg fCAgIDIyICstCmRvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgICAgICAgICAgICAgICAgICAg ICAgIHwgICAgNSArCmRvYy9zcmMvc2dtbC9wcm90b2NvbC5zZ21sICAgICAgICAgICAgICAgICAg ICAgICAgIHwgICAyOSArLQpkb2Mvc3JjL3NnbWwvcmVmL2NyZWF0ZV9zdWJzY3JpcHRpb24uc2dt bCAgICAgICAgICB8ICAgMjQgKy0KZG9jL3NyYy9zZ21sL3N5c3RlbS12aWV3cy5zZ21sICAgICAg ICAgICAgICAgICAgICAgfCAgIDE0ICstCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hhY3Qu YyAgICAgICAgICAgICAgICAgIHwgICAyNCArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9zdWJzY3Jp cHRpb25jbWRzLmMgICAgICAgICAgICB8ICAgNjcgKy0Kc3JjL2JhY2tlbmQvbGlicHEvcHFtcS5j ICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDE4ICstCnNyYy9iYWNrZW5kL3Bvc3RtYXN0 ZXIvYmd3b3JrZXIuYyAgICAgICAgICAgICAgICAgIHwgICAgMyArCnNyYy9iYWNrZW5kL3Bvc3Rt YXN0ZXIvaW50ZXJydXB0LmMgICAgICAgICAgICAgICAgIHwgICAgNSArLQouLi4vbGlicHF3YWxy ZWNlaXZlci9saWJwcXdhbHJlY2VpdmVyLmMgICAgICAgICAgICB8ICAgIDYgKy0Kc3JjL2JhY2tl bmQvcmVwbGljYXRpb24vbG9naWNhbC9NYWtlZmlsZSAgICAgICAgICAgfCAgICAxICsKLi4uL3Jl cGxpY2F0aW9uL2xvZ2ljYWwvYXBwbHlwYXJhbGxlbHdvcmtlci5jICAgICAgfCAxNjMwICsrKysr KysrKysrKysrKysrKysrCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvZGVjb2RlLmMg ICAgICAgICAgIHwgICAgNSArLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL2xhdW5j aGVyLmMgICAgICAgICB8ICAyMjAgKystCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwv bWVzb24uYnVpbGQgICAgICAgIHwgICAgMSArCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2lj YWwvb3JpZ2luLmMgICAgICAgICAgIHwgICAyNiArLQpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9s b2dpY2FsL3Byb3RvLmMgICAgICAgICAgICB8ICAgMzcgKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRp b24vbG9naWNhbC9yZW9yZGVyYnVmZmVyLmMgICAgfCAgICA1ICstCnNyYy9iYWNrZW5kL3JlcGxp Y2F0aW9uL2xvZ2ljYWwvdGFibGVzeW5jLmMgICAgICAgIHwgICAyNSArLQpzcmMvYmFja2VuZC9y ZXBsaWNhdGlvbi9sb2dpY2FsL3dvcmtlci5jICAgICAgICAgICB8IDEzODYgKysrKysrKysrKysr KystLS0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vcGdvdXRwdXQvcGdvdXRwdXQuYyAgICAgICAg fCAgIDIyICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvaXBjL3Byb2NzaWduYWwuYyAgICAgICAgICAg ICAgIHwgICAgNCArCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1nci9sbWdyLmMgICAgICAgICAgICAg ICAgICAgIHwgICA0NiArCnNyYy9iYWNrZW5kL3Rjb3AvcG9zdGdyZXMuYyAgICAgICAgICAgICAg ICAgICAgICAgIHwgICAgMyArCnNyYy9iYWNrZW5kL3V0aWxzL2FjdGl2aXR5L3dhaXRfZXZlbnQu YyAgICAgICAgICAgIHwgICAgNiArCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9sb2NrZnVuY3MuYyAg ICAgICAgICAgICAgICAgIHwgICAxNiArLQpzcmMvYmFja2VuZC91dGlscy9taXNjL2d1Y190YWJs ZXMuYyAgICAgICAgICAgICAgICB8ICAgMTIgKwpzcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3Rn cmVzcWwuY29uZi5zYW1wbGUgICAgICB8ICAgIDEgKwpzcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5j ICAgICAgICAgICAgICAgICAgICAgICAgICB8ICAgIDYgKy0Kc3JjL2Jpbi9wc3FsL2Rlc2NyaWJl LmMgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDIxICstCnNyYy9pbmNsdWRlL2NhdGFs b2cvY2F0dmVyc2lvbi5oICAgICAgICAgICAgICAgICAgIHwgICAgMiArLQpzcmMvaW5jbHVkZS9j YXRhbG9nL3BnX3N1YnNjcmlwdGlvbi5oICAgICAgICAgICAgICB8ICAgMjEgKy0Kc3JjL2luY2x1 ZGUvY29tbWFuZHMvc3Vic2NyaXB0aW9uY21kcy5oICAgICAgICAgICAgfCAgICAyICsKc3JjL2lu Y2x1ZGUvcmVwbGljYXRpb24vbG9naWNhbGxhdW5jaGVyLmggICAgICAgICAgfCAgICAxICsKc3Jj L2luY2x1ZGUvcmVwbGljYXRpb24vbG9naWNhbHByb3RvLmggICAgICAgICAgICAgfCAgIDI4ICst CnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9uL2xvZ2ljYWx3b3JrZXIuaCAgICAgICAgICAgIHwgICAg OSArCnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9uL29yaWdpbi5oICAgICAgICAgICAgICAgICAgIHwg ICAgMiArLQpzcmMvaW5jbHVkZS9yZXBsaWNhdGlvbi9wZ291dHB1dC5oICAgICAgICAgICAgICAg ICB8ICAgIDIgKy0Kc3JjL2luY2x1ZGUvcmVwbGljYXRpb24vcmVvcmRlcmJ1ZmZlci5oICAgICAg ICAgICAgfCAgICA0ICstCnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9uL3dhbHJlY2VpdmVyLmggICAg ICAgICAgICAgIHwgICAgMiArLQpzcmMvaW5jbHVkZS9yZXBsaWNhdGlvbi93b3JrZXJfaW50ZXJu YWwuaCAgICAgICAgICB8ICAyMjcgKystCnNyYy9pbmNsdWRlL3N0b3JhZ2UvbG1nci5oICAgICAg ICAgICAgICAgICAgICAgICAgIHwgICAgNSArCnNyYy9pbmNsdWRlL3N0b3JhZ2UvbG9jay5oICAg ICAgICAgICAgICAgICAgICAgICAgIHwgICAxNyArLQpzcmMvaW5jbHVkZS9zdG9yYWdlL3Byb2Nz aWduYWwuaCAgICAgICAgICAgICAgICAgICB8ICAgIDEgKwpzcmMvaW5jbHVkZS91dGlscy93YWl0 X2V2ZW50LmggICAgICAgICAgICAgICAgICAgICB8ICAgIDIgKwpzcmMvdGVzdC9yZWdyZXNzL2V4 cGVjdGVkL3N1YnNjcmlwdGlvbi5vdXQgICAgICAgICB8ICAgNDYgKy0Kc3JjL3Rlc3QvcmVncmVz cy9zcWwvc3Vic2NyaXB0aW9uLnNxbCAgICAgICAgICAgICAgfCAgICA2ICstCnNyYy90ZXN0L3N1 YnNjcmlwdGlvbi90LzAxNV9zdHJlYW0ucGwgICAgICAgICAgICAgIHwgIDI3NCArKystCnNyYy90 ZXN0L3N1YnNjcmlwdGlvbi90LzAxNl9zdHJlYW1fc3VieGFjdC5wbCAgICAgIHwgIDEzMCArLQpz cmMvdGVzdC9zdWJzY3JpcHRpb24vdC8wMTdfc3RyZWFtX2RkbC5wbCAgICAgICAgICB8ICAgIDMg KwouLi4vc3Vic2NyaXB0aW9uL3QvMDE4X3N0cmVhbV9zdWJ4YWN0X2Fib3J0LnBsICAgICB8ICAy MjAgKystCi4uLi9zdWJzY3JpcHRpb24vdC8wMTlfc3RyZWFtX3N1YnhhY3RfZGRsX2Fib3J0LnBs IHwgICAgMyArCnNyYy90ZXN0L3N1YnNjcmlwdGlvbi90LzAyMl90d29waGFzZV9jYXNjYWRlLnBs ICAgIHwgICAgMiArCnNyYy90ZXN0L3N1YnNjcmlwdGlvbi90LzAyM190d29waGFzZV9zdHJlYW0u cGwgICAgIHwgIDUyNSArKysrLS0tCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0ICAg ICAgICAgICAgICAgICAgIHwgICAgNyArCjU4IGZpbGVzIGNoYW5nZWQsIDQ1MTEgaW5zZXJ0aW9u cygrKSwgNzU5IGRlbGV0aW9ucygtKQoK --===============3185809040901678654==--