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 1oUEpT-0005cD-Nn for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Sep 2022 22:08:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oUEpS-0004C5-K3 for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Sep 2022 22:07:58 +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 1oUEpS-0003z5-0n for pgsql-hackers@lists.postgresql.org; Fri, 02 Sep 2022 22:07:58 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oUEpJ-0007Z7-Ct for pgsql-hackers@postgresql.org; Fri, 02 Sep 2022 22:07:57 +0000 Received: by mail-pl1-x62e.google.com with SMTP id j5so3141635plj.5 for ; Fri, 02 Sep 2022 15:07:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date; bh=f+Jl9O3p/VZfA0T+i/tNNstrm/D7NKdRqkqSTqwHAZU=; b=JVFqsQSmyfe/GOmzwz2Bz3pgdc/HJtZdA+xvAoQAkJpAGuYkYKzrmAfumu40wS/KN/ LlP6iWL9JlCitySyZxzO0BuOLgSbMbdvsfqt+rkWqSFaeqXwdJepRsPz5BiIfN/Mb8DL 3ewNOEm/3CwT8CNSZTpRnQk8ZpEpF1ET45qY+2iwdYUXY9k+7UY3c80cX76YfQk5PGiZ KGIm9fixPV8KhsKB+PViR58zNXiCTeHRFpy/Ns8pW1tCDNw712k9B8U0YXOhYmH23cng VGIb+XTLVgXsoLVcKJcfrRnb7PgF5bOALBNFIfM6Gd95KgPQz8m194BU7AZPNRMinYDM 3QSQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; 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; bh=f+Jl9O3p/VZfA0T+i/tNNstrm/D7NKdRqkqSTqwHAZU=; b=TBxIZKgKphzxX3neLHmZaTuxMgGhpUMMf6UW5TQDlIM4+fx/alR6sThX+6jmqNnAIv 8G2b6U9JDHuIbd0g/zE5L+8ynFhuU8fOd6BEjZVZfs77gW4DJmoaMISbwG5b3wfnOvUv EAODG36FcRhYR9kTaScUIx/2rXFptjl6hQoUybFN6FbJBo4e1MmcBYPKXsmReaRs0/aJ xQ5fAX7uZhjYD/Myde7h4dt5UCwRc/JrczvFez4EOp2mmqV3jz75SwUxAKTVgq3CEexV 6OLej4A+CJPikl9gW0ssTMaxvIlgCpTuLwQctNdUkIDZrhecvP5eVYqkWjZtfyyp9NdY 1YnA== X-Gm-Message-State: ACgBeo2E4FRMZXHey3hSIX43Cuojm5ACOOcquRvXW0FPfJf0IZz32PeV nIa8CBCKE8Cqi6VRJp95Sk8= X-Google-Smtp-Source: AA6agR7KEntFQniuGRTHp9n1i4eJB+zjBHdqFSUuNtJJvnkYjVhYgmnwP/DXCCnyzvLCnJuCqBVrdQ== X-Received: by 2002:a17:90b:17d0:b0:1fe:3256:d10a with SMTP id me16-20020a17090b17d000b001fe3256d10amr7058219pjb.125.1662156466878; Fri, 02 Sep 2022 15:07:46 -0700 (PDT) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id 68-20020a621847000000b00536779d43e7sm2317631pfy.201.2022.09.02.15.07.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 02 Sep 2022 15:07:45 -0700 (PDT) Date: Fri, 2 Sep 2022 15:07:44 -0700 From: Nathan Bossart To: Andres Freund Cc: Simon Riggs , Robert Haas , "Bossart, Nathan" , Bharath Rupireddy , Maxim Orlov , Amul Sul , Bruce Momjian , "pgsql-hackers@postgresql.org" Subject: Re: O(n) tasks cause lengthy startups and checkpoints Message-ID: <20220902220744.GA1261322@nathanxps13> References: <20220623171552.GA96638@nathanxps13> <20220702220554.GA1044460@nathanxps13> <20220702225456.zit5kjdtdfqmjujt@alap3.anarazel.de> <20220703170754.GA1048244@nathanxps13> <20220703172732.wembjsb55xl63vuw@awork3.anarazel.de> <20220706165110.GB2135371@nathanxps13> <20220811230921.GA1707962@nathanxps13> <20220824164624.GA1302727@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="+QahgC5+KEYLbs62" Content-Disposition: inline In-Reply-To: <20220824164624.GA1302727@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --+QahgC5+KEYLbs62 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Aug 24, 2022 at 09:46:24AM -0700, Nathan Bossart wrote: > Another rebase for cfbot. And another. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com --+QahgC5+KEYLbs62 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v10-0001-Introduce-custodian.patch"