| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
| Cc: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: O(n) tasks cause lengthy startups and checkpoints |
| Date: | 2021-12-13 20:36:24 |
| Message-ID: | CA+TgmobGy9WoxoOsSRiMFvWtd=93S_9YYOg0bv+AJC4E1Orv0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Dec 13, 2021 at 1:21 PM Bossart, Nathan <bossartn(at)amazon(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2021-12-13 20:40:09 | Re: extended stats on partitioned tables |
| Previous Message | Tom Lane | 2021-12-13 20:33:30 | Re: bugfix: invalid bit/varbit input causes the log file to be unreadable |