Re: O(n) tasks cause lengthy startups and checkpoints - Mailing list pgsql-hackers

From Robert Haas
Subject Re: O(n) tasks cause lengthy startups and checkpoints
Date
Msg-id CA+TgmobGy9WoxoOsSRiMFvWtd=93S_9YYOg0bv+AJC4E1Orv0w@mail.gmail.com
Whole thread Raw
In response to Re: O(n) tasks cause lengthy startups and checkpoints  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: O(n) tasks cause lengthy startups and checkpoints  ("Bossart, Nathan" <bossartn@amazon.com>)
List pgsql-hackers
On Mon, Dec 13, 2021 at 1:21 PM Bossart, Nathan <bossartn@amazon.com> wrote:
> > But against all that, if these tasks are slowing down checkpoints and
> > that's avoidable, that seems pretty important too. Interestingly, I
> > can't say that I've ever seen any of these things be a problem for
> > checkpoint or startup speed. I wonder why you've had a different
> > experience.
>
> Yeah, it's difficult for me to justify why users should suffer long
> periods of downtime because startup or checkpointing is taking a very
> long time doing things that are arguably unrelated to startup and
> checkpointing.

Well sure. But I've never actually seen that happen.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: bugfix: invalid bit/varbit input causes the log file to be unreadable
Next
From: Tomas Vondra
Date:
Subject: Re: extended stats on partitioned tables