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 1qGkuJ-0007Dl-6A for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jul 2023 18:37:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qGkuI-0001Xp-3A for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Jul 2023 18:37:46 +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 1qGkuH-0001Xg-Oy for pgsql-hackers@lists.postgresql.org; Tue, 04 Jul 2023 18:37:45 +0000 Received: from mail-pj1-x1033.google.com ([2607:f8b0:4864:20::1033]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qGkuE-002CNx-QU for pgsql-hackers@postgresql.org; Tue, 04 Jul 2023 18:37:45 +0000 Received: by mail-pj1-x1033.google.com with SMTP id 98e67ed59e1d1-262d9e75438so4137103a91.2 for ; Tue, 04 Jul 2023 11:37:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688495860; x=1691087860; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=mvXSjPKz54hhEgqlF1Gz9oXJXiEbwngvPQgcw9oOXe0=; b=nZTWNrGRf0Xl6ymexJ2Wr7gcGHIUvfdBTajOxxhuWxdcssDcfFFLy/aRxTPTjW4M/n OAPlDcrPJdrvJyUJcT5T1U4R3oRymlAXfZmCNFcHhHKx5KGpwwp3DWBmnDy7J+eKn8FE +F6HhelF/hbJFLplisymdNywyu2Rtt20/3RlzimpqfyenHJ1FmO/0pHP1LMC091Y3aqE FTIr4odKwa2vakhg0j5SELKuau749/8DaSYLLvbsZ5cvPvmZORm3Ya+eOt8mvLsqkkwu CNa0KqRDsm6s0h5eRbSYMbCDjlM5zqmx8q9ZW0rNEbulU7twhZTJqSTmSj3PdFPg3jCe 8mOA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688495860; x=1691087860; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=mvXSjPKz54hhEgqlF1Gz9oXJXiEbwngvPQgcw9oOXe0=; b=DnM91rm7sOmVxEnDkvkSlM5Q+LGj3r9bxZg3DqnGGNl4ab7L98MQXJEU8binVhs6QY u98df7DiHhHs5qUdTt0nwZ8kEBuCFXkZ9oqqZU1Ieg6X7QXr7PfgJvd3uyFEPtqukVi0 9NN92PuTDrTNANZ6m46Ptv4vNqK6E3cfkeR3cVVTpozcBs9QY//OtwtuoXBnsWgWxLcK x6iePegdqKhWh+p2Y9VSPpvDZdnF4w3cxCB/VTiMz7ab9cHa3Kg2PE/mgHpHUoyEToIL x6urc25jyvHPVUQrY8KvetObCHSiyeQi3o9vDpVZ14vaoBYqZWKg7MmhkD3qH0KCvNLe RA/Q== X-Gm-Message-State: ABy/qLatzFiprizBrMzAz4QbT3jSrJtqFDDJMcxdKv/06sDUNOpmwWVT sYYEkEIuHTz/TDOk71X+t5c= X-Google-Smtp-Source: APBJJlGeUd4LYMcGi78rLSXUS3NZIYxUKmBC0ZFDUHqs3f2qIzSpv3QNCEC/nRD/jSj2Svhyk4mjPw== X-Received: by 2002:a17:90b:3105:b0:262:e598:6046 with SMTP id gc5-20020a17090b310500b00262e5986046mr15735301pjb.28.1688495859883; Tue, 04 Jul 2023 11:37:39 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id c14-20020a17090a020e00b0025bbe90d3cbsm18619224pjc.44.2023.07.04.11.37.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 04 Jul 2023 11:37:39 -0700 (PDT) Date: Tue, 4 Jul 2023 11:37:36 -0700 From: Nathan Bossart To: Daniel Gustafsson Cc: Tom Lane , Andres Freund , Bharath Rupireddy , Robert Haas , "Bossart, Nathan" , Maxim Orlov , Amul Sul , Bruce Momjian , PostgreSQL Hackers Subject: Re: O(n) tasks cause lengthy startups and checkpoints Message-ID: <20230704183736.GA3375715@nathanxps13> References: <20230203054808.GA83788@nathanxps13> <20230217234344.GA3357392@nathanxps13> <1031491.1680457205@sss.pgh.pa.us> <20230402184226.kkjplqvqu6utvzbt@awork3.anarazel.de> <20230402195005.GB25018@nathanxps13> <1058306.1680467858@sss.pgh.pa.us> <20230402213152.GB27239@nathanxps13> <20230404033626.GB29745@nathanxps13> <3B4FA602-1CC6-49FC-9BFE-17F6DF416C3D@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3B4FA602-1CC6-49FC-9BFE-17F6DF416C3D@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jul 04, 2023 at 09:30:43AM +0200, Daniel Gustafsson wrote: >> On 4 Apr 2023, at 05:36, Nathan Bossart wrote: >> >> I sent this one to the next commitfest and marked it as waiting-on-author >> and targeted for v17. I'm aiming to have something that addresses the >> latest feedback ready for the July commitfest. > > Have you had a chance to look at this such that there is something ready? Not yet, sorry. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com