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 1oxzxX-0007hJ-Uk for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Nov 2022 00:19:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oxzxW-0001RY-M7 for pgsql-hackers@arkaria.postgresql.org; Thu, 24 Nov 2022 00:19:18 +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 1oxzxV-0001QE-TO for pgsql-hackers@lists.postgresql.org; Thu, 24 Nov 2022 00:19:18 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1oxzxQ-0002WD-GJ for pgsql-hackers@postgresql.org; Thu, 24 Nov 2022 00:19:16 +0000 Received: by mail-pf1-x429.google.com with SMTP id 9so174805pfx.11 for ; Wed, 23 Nov 2022 16:19:12 -0800 (PST) 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:message-id:reply-to; bh=9N+aeKb9m/ucIHQVC80LSgeGcC5hFupoHgfbbIGxfL8=; b=VIQEnIuknbgca1creByuklkKp72+6Wke0W/ttLwjjoBSX/a/EW04o2zy71eNN6tMtl GwfS6cvax57jp5hqUkkH/+mRc9mp6CbM1f6GC0ydoi0SCLFEMhYreeaNMhqTs6a3P6wM dzeghkHnB9ipZHgf7bQBO5NejxCSirF8jNlQkrr9gu13iW9gHPBuM+7idsH35/8VK8wx ifzZwv87uwpGy31HoIUWOimif6P2ZiBiybi6inr9iC8x+OdED/om/KJBF9RxgzV7RNF1 pYKhh/qnZAt3opSQ51gn1JRVN02m9cWzoc2FRzx5g0FayTtG44o00UAZ4ihcC33Dprzx n18A== 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 :message-id:reply-to; bh=9N+aeKb9m/ucIHQVC80LSgeGcC5hFupoHgfbbIGxfL8=; b=KatbHOjU6b5YlaWMtCogeosWdQ5exRnYRzk5zcnmr4QTM69Sntij0UbboK1flpcWpc kvinlt3oa3ihVeU/xpvyTbrnWD2q6wej1cGm5Bf0l0WH4qAaqrjqbaOJYNQMHXTYoKyB WDHk11BjjleNc0RFs8PVd70oaGLPM2gmBeSeZ8gThFjzI0at1gDfbG6z8r9pdzkKVJsm 46UnvFnbkU8djTWYAYrDSVhjRXaSxrli03tGF32tPdKh06F2/Aly3wCZQk4yPDX7pR20 zrhFTUBtTrrt+JLjt2xTfYmkqdU9S5QeaDTSkc3HxJLjHv5sbfOj4IWP/gXZgjwrGNgG k4Xw== X-Gm-Message-State: ANoB5pnLm3ZNjEBaW9Y8rUPjOv1OAUzBOFWiJDdR/mN4gGspvGhPpxvf 6gSyOHLzcbUerYz6ja5NEE0= X-Google-Smtp-Source: AA0mqf57DSIl23lRd9lc9lIucEVqBbqNUPHFGG66TeA505tmlUBxFsSuO/B/auR5bPd2TZRLjNPEsg== X-Received: by 2002:a65:560a:0:b0:477:382d:dd38 with SMTP id l10-20020a65560a000000b00477382ddd38mr10335025pgs.264.1669249150505; Wed, 23 Nov 2022 16:19:10 -0800 (PST) Received: from nathanxps13 ([50.47.162.83]) by smtp.gmail.com with ESMTPSA id x22-20020a170902821600b0017f48a9e2d6sm14670099pln.292.2022.11.23.16.19.09 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 23 Nov 2022 16:19:09 -0800 (PST) Date: Wed, 23 Nov 2022 16:19:07 -0800 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: <20221124001907.GA576983@nathanxps13> References: <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> <20220902220744.GA1261322@nathanxps13> <20220923174154.GA1111614@nathanxps13> <20221106223842.GA620653@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="CE+1k2dSO48ffgeK" Content-Disposition: inline In-Reply-To: <20221106223842.GA620653@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sun, Nov 06, 2022 at 02:38:42PM -0800, Nathan Bossart wrote: > rebased another rebase for cfbot -- Nathan Bossart Amazon Web Services: https://aws.amazon.com --CE+1k2dSO48ffgeK Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="v13-0001-Introduce-custodian.patch"