From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | "Bossart, Nathan" <bossartn(at)amazon(dot)com> |
Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, "k(dot)jamison(at)fujitsu(dot)com" <k(dot)jamison(at)fujitsu(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)com> |
Subject: | Re: please update ps display for recovery checkpoint |
Date: | 2021-06-07 17:28:06 |
Message-ID: | CA+TgmobcNEnW-ufjvMEhXYsgabqGtQRC7MY=9-McYjQo4-mVEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Jun 7, 2021 at 12:02 PM Bossart, Nathan <bossartn(at)amazon(dot)com> wrote:
> On 6/6/21, 7:14 PM, "Justin Pryzby" <pryzby(at)telsasoft(dot)com> wrote:
> > Now, I wonder whether the startup process should also include some detail about
> > "syncing data dir". It's possible to strace the process to see what it's
> > doing, but most DBA would probably not know that, and it's helpful to know the
> > status of recovery and what part of recovery is slow: sync, replay, or
> > checkpoint. commit df9274adf improved the situation between replay and
> > ckpoint, but it's still not clear what "postgres: startup" means before replay
> > starts.
>
> I've seen a few functions cause lengthy startups, including
> SyncDataDirectory() (for which I was grateful to see 61752afb),
> StartupReorderBuffer(), and RemovePgTempFiles(). I like the idea of
> adding additional information in the ps title, but I also think it is
> worth exploring additional ways to improve on these O(n) startup
> tasks.
See also the nearby thread entitled "when the startup process doesn't"
which touches on this same issue.
--
Robert Haas
EDB: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2021-06-07 18:20:38 | Re: Duplicate history file? |
Previous Message | Bossart, Nathan | 2021-06-07 16:02:03 | Re: please update ps display for recovery checkpoint |