agora inbox for pgsql-hackers@postgresql.org  
help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Bossart, Nathan <bossartn@amazon.com>
Cc: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: Maxim Orlov <orlovmg@gmail.com>
Cc: Amul Sul <sulamul@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: O(n) tasks cause lengthy startups and checkpoints
Date: Fri, 18 Feb 2022 12:51:11 -0800
Message-ID: <20220218205111.GA3447220@nathanxps13> (raw)
In-Reply-To: <20220218164454.GA3403811@nathanxps13>
References: <20220217015052.2y3wxibeommk37ey@alap3.anarazel.de>
	<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>

> On Thu, Feb 17, 2022 at 03:12:47PM -0800, Andres Freund wrote:
>>> > The improvements around deleting temporary files and serialized snapshots
>>> > afaict don't require a dedicated process - they're only relevant during
>>> > startup. We could use the approach of renaming the directory out of the way as
>>> > done in this patchset but perform the cleanup in the startup process after
>>> > we're up.

BTW I know you don't like the dedicated process approach, but one
improvement to that approach could be to shut down the custodian process
when it has nothing to do.

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com





view thread (89+ messages)  latest in thread

Message-ID: <20220218205111.GA3447220@nathanxps13>
Permalink:  ../20220218205111.GA3447220@nathanxps13/
Also on:    postgresql.org/message-id/20220218205111.GA3447220@nathanxps13

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: nathandbossart@gmail.com, andres@anarazel.de, bossartn@amazon.com, bharath.rupireddyforpostgres@gmail.com, orlovmg@gmail.com, sulamul@gmail.com, bruce@momjian.us, robertmhaas@gmail.com
  Subject: Re: O(n) tasks cause lengthy startups and checkpoints
  In-Reply-To: <20220218205111.GA3447220@nathanxps13>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox