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 1nUzE6-00056j-5f for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Mar 2022 23:08:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nUzE3-0005Bb-DO for pgsql-hackers@arkaria.postgresql.org; Thu, 17 Mar 2022 23:08:11 +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 1nUzE3-0005A6-2t for pgsql-hackers@lists.postgresql.org; Thu, 17 Mar 2022 23:08:11 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nUzDv-0006Bd-Nx for pgsql-hackers@postgresql.org; Thu, 17 Mar 2022 23:08:10 +0000 Received: by mail-pj1-x102b.google.com with SMTP id n7-20020a17090aab8700b001c6aa871860so755252pjq.2 for ; Thu, 17 Mar 2022 16:08:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=51OoKe0LfqtwFz4rcmCsqlwukbQwocy/t9TuVF4P00M=; b=foiyBum1YOtcRbWNsOa5pTAHkj4TyAADpAmiLSw6XIzuhWkYXmG9ZxCdAGUhVP5d2X mN2pk8am/WuuV9FMPMitHAR64l2QwqWtdo5nYKXa6hDVcSARfofCGZzVoalF4khvHoDZ fJJjRRTnscLYbxJ/SXXQpFQDQ7v+jLpYH0liTX1CAEbHSvuKwLSm13GtNeM6hMOGN+/z nCB+pfit/CrpPz/3uTfVbIaZGv9h+z9gcBd2SCYTFt6+XIVYgh9jh4KFDt+VMT0+lqHQ aq/xlqXhVAd+XfZwJ2TLQufYnAcdWMl6z5ixFSLmVJi1hfpt0Sgf/9/fqeOwZLX6wG9/ O19g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=51OoKe0LfqtwFz4rcmCsqlwukbQwocy/t9TuVF4P00M=; b=tLmwQtKMc8XDYfIoKrFi5Lmh6F/f2YCSXe4boGb5VYmrs/I6qJqiEh8rlbHT2oXK3R bho1yq2gR7vkIER39wWX/8d+Bdz6SflpHL+fkXHyV/CvofWqaYIc0SXyqllryyrIHjQG 3H2TSwreqaktaSDNnA9L/YNRPJI3ieuz+Gg+MKFVPTFfAJf8A6ThYDE/MpfvT3i5o91Q GVsMaR0B93MfKhzmW/nUlT83zn4VraqcSiODmTF4G2GsNgNHNXrDt3EFTeb4KZ5o3Qiw 82oAd8F9DHIpPpTkGfzE4u+Z28fEUDz8sm/gD+EylroZjQgQrat55VPeT5brY/TxpwhI ihUg== X-Gm-Message-State: AOAM53156t1f9joZ08ds+qcT4Msrqnwu4CnkCyXfZ2hgFk91g2kSq5JS RCxVEqtpGF7K9jHoAcerz4g= X-Google-Smtp-Source: ABdhPJweYTsMeVZmpN3rUFLXOrr9gFx1FCs/yJ7LlPWb/RDlZdVTt/IRiCInqKYvF2TOe5cA81Maog== X-Received: by 2002:a17:903:228d:b0:154:156:eb79 with SMTP id b13-20020a170903228d00b001540156eb79mr3198031plh.51.1647558481954; Thu, 17 Mar 2022 16:08:01 -0700 (PDT) Received: from nathanxps13 ([50.54.155.70]) by smtp.gmail.com with ESMTPSA id c7-20020aa78e07000000b004f6e4d8ccc8sm7486575pfr.163.2022.03.17.16.08.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 17 Mar 2022 16:08:01 -0700 (PDT) Date: Thu, 17 Mar 2022 16:07:58 -0700 From: Nathan Bossart To: Andres Freund Cc: "Bossart, Nathan" , Bharath Rupireddy , Maxim Orlov , Amul Sul , Bruce Momjian , Robert Haas , "pgsql-hackers@postgresql.org" Subject: Re: O(n) tasks cause lengthy startups and checkpoints Message-ID: <20220317230758.GA1415284@nathanxps13> References: <20220217041404.GA3243546@nathanxps13> <20220217065938.x2esfdppzypegn5j@alap3.anarazel.de> <20220217182337.GA3247866@nathanxps13> <20220217192709.eyf2cnymhxqsals7@alap3.anarazel.de> <20220217210022.GA3248793@nathanxps13> <20220217222829.lndzwq72fh4v34c2@alap3.anarazel.de> <20220217225838.GA3292179@nathanxps13> <20220217231247.llfqjvvuk6rkawel@alap3.anarazel.de> <20220218164454.GA3403811@nathanxps13> <20220218205111.GA3447220@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20220218205111.GA3447220@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk It seems unlikely that anything discussed in this thread will be committed for v15, so I've adjusted the commitfest entry to v16 and moved it to the next commitfest. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com