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 1mxEBN-0008GW-Jm for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Dec 2021 20:13:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxEBM-0001qQ-AV for pgsql-hackers@arkaria.postgresql.org; Tue, 14 Dec 2021 20:13:52 +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 1mxEBM-0001qH-0o for pgsql-hackers@lists.postgresql.org; Tue, 14 Dec 2021 20:13:52 +0000 Received: from smtp-fw-6001.amazon.com ([52.95.48.154]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxEBF-0005bJ-QS for pgsql-hackers@postgresql.org; Tue, 14 Dec 2021 20:13:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1639512826; x=1671048826; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-id:content-transfer-encoding: mime-version; bh=vZan3vb6wEtGdQmM4nCszBjQUSW6i23fupv36Wbxi6A=; b=Z5a00kz64mk/Jdz8M8yh0qJ++klseGK7oHLHKYE0Qa6+1glpa7eD9h4y WOLA9qi8KMmQ/fQVUEU+nVpHneGu3jZ/sLvedJVbQkZBU2szosxv8wmSf p0lbxwcM4ZwUyXid2AURvkHgA+5yufbs7zaGi1HchdcEsQ1LKvomYIPDW E=; X-IronPort-AV: E=Sophos;i="5.88,206,1635206400"; d="scan'208";a="163510684" Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-pdx-2c-1cb212d9.us-west-2.amazon.com) ([10.43.8.6]) by smtp-border-fw-6001.iad6.amazon.com with ESMTP; 14 Dec 2021 20:13:44 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2c-1cb212d9.us-west-2.amazon.com (Postfix) with ESMTPS id 8ECC889EDC; Tue, 14 Dec 2021 20:13:42 +0000 (UTC) Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Tue, 14 Dec 2021 20:13:38 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC003.ant.amazon.com (10.43.162.79) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Tue, 14 Dec 2021 20:13:38 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.026; Tue, 14 Dec 2021 20:13:38 +0000 From: "Bossart, Nathan" To: Bruce Momjian CC: Robert Haas , Bharath Rupireddy , "pgsql-hackers@postgresql.org" Subject: Re: O(n) tasks cause lengthy startups and checkpoints Thread-Topic: O(n) tasks cause lengthy startups and checkpoints Thread-Index: AQHX8ScUdobVSJNuXEOId/gI0+YBAg== Date: Tue, 14 Dec 2021 20:13:38 +0000 Message-ID: References: <5E58EBB2-3DAE-4400-9EBE-60D1FE4C5B10@amazon.com> <8ACCEA4C-BA36-494B-92B4-EF14DAF1BC3B@amazon.com> <2B230EF6-7509-479C-8C5A-34B56A1B4063@amazon.com> <6DFA78EC-EF4D-4CB0-82C8-AD5DA1B8E0AC@amazon.com> <32B93472-B51D-491A-B7AF-45DD8927D981@amazon.com> <2ED889A4-8EE8-4C94-9158-38F80B661071@amazon.com> <20211214165950.GB30945@momjian.us> <803C7D41-64FD-4079-B85C-FE1E3076555C@amazon.com> In-Reply-To: <803C7D41-64FD-4079-B85C-FE1E3076555C@amazon.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.102] Content-Type: text/plain; charset="utf-8" Content-ID: <24FDBE876AA7784497F109475B06C25D@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTIvMTQvMjEsIDEyOjA5IFBNLCAiQm9zc2FydCwgTmF0aGFuIiA8Ym9zc2FydG5AYW1hem9u LmNvbT4gd3JvdGU6DQo+IE9uIDEyLzE0LzIxLCA5OjAwIEFNLCAiQnJ1Y2UgTW9tamlhbiIgPGJy dWNlQG1vbWppYW4udXM+IHdyb3RlOg0KPj4gSGF2ZSB3ZSBjaGFuZ2VkIHRlbXBvcmFyeSBmaWxl IGhhbmRsaW5nIGluIGFueSByZWNlbnQgbWFqb3IgcmVsZWFzZXMsDQo+PiBtZWFuaW5nIGlzIHRo aXMgYSBjdXJyZW50IHByb2JsZW0gb3Igb25lIGFscmVhZHkgaW1wcm92ZWQgaW4gUEcgMTQuDQo+ DQo+IEkgaGF2ZW4ndCBub3RpY2VkIGFueSByZWNlbnQgaW1wcm92ZW1lbnRzIHdoaWxlIHdvcmtp bmcgaW4gdGhpcyBhcmVhLg0KDQpPbiBzZWNvbmQgdGhvdWdodCwgdGhlIGFkZGl0aW9uIG9mIHRo ZSByZW1vdmVfdGVtcF9maWxlc19hZnRlcl9jcmFzaA0KR1VDIGlzIGFyZ3VhYmx5IGFuIGltcHJv dmVtZW50IHNpbmNlIGl0IGNvdWxkIHByZXZlbnQgZmlsZXMgZnJvbQ0KYWNjdW11bGF0aW5nIGFm dGVyIHJlcGVhdGVkIGNyYXNoZXMuDQoNCk5hdGhhbg0KDQo=