Re: O(n) tasks cause lengthy startups and checkpoints

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Maxim Orlov <orlovmg(at)gmail(dot)com>, Amul Sul <sulamul(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: O(n) tasks cause lengthy startups and checkpoints
Date: 2022-11-30 05:18:33
Message-ID: 20221130051833.GB1677223@nathanxps13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Tue, Nov 29, 2022 at 07:56:53PM -0800, Nathan Bossart wrote:
> On Tue, Nov 29, 2022 at 12:02:44PM +0000, Simon Riggs wrote:
>> The last important point for me is tests, in src/test/modules
>> probably. It might be possible to reuse the final state of other
>> modules' tests to test cleanup, or at least integrate a custodian test
>> into each module.
> Of course. I found some existing tests for the test_decoding plugin that
> appear to reliably generate the files we want the custodian to clean up, so
> I added them there.

cfbot is not happy with v16. AFAICT this is just due to poor placement, so
here is another attempt with the tests moved to a new location. Apologies
for the noise.

Nathan Bossart
Amazon Web Services:

Attachment Content-Type Size
v17-0001-Introduce-custodian.patch text/x-diff 24.3 KB
v17-0002-Move-removal-of-old-serialized-snapshots-to-cust.patch text/x-diff 6.3 KB
v17-0003-Move-removal-of-old-logical-rewrite-mapping-file.patch text/x-diff 10.6 KB
v17-0004-Do-not-delay-shutdown-due-to-long-running-custod.patch text/x-diff 2.9 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-11-30 05:22:57 Re: pg_dump bugs reported as pg_upgrade bugs
Previous Message Nathan Bossart 2022-11-30 05:04:41 Re: wake up logical workers after ALTER SUBSCRIPTION