pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedClarification of pg_cotroldata output
2+ messages / 2 participants
[nested] [flat]
* Clarification of pg_cotroldata output
@ 2011-01-27 20:04 Melvin Davidson <mdavidson@icsolutions.com>
0 siblings, 1 reply; 2+ messages in thread
From: Melvin Davidson @ 2011-01-27 20:04 UTC (permalink / raw)
To: pgsql-admin
*Can someone please clarify?
When I execute pg_control on a warm standby cluster, I notice that often,
"Time of latest checkpoint:" lags behind "pg_control last modified:".
Is it documented anywhere the difference between "pg_control last modified:"
and "Time of latest checkpoint:" ?
Thanks in advance!
Melvin
*
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Clarification of pg_cotroldata output
@ 2011-01-31 18:48 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Melvin Davidson <mdavidson@icsolutions.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2011-01-31 18:48 UTC (permalink / raw)
To: Melvin Davidson <mdavidson@icsolutions.com>; pgsql-admin
Melvin Davidson <mdavidson@icsolutions.com> wrote:
> When I execute pg_control on a warm standby cluster, I notice that
> often, "Time of latest checkpoint:" lags behind "pg_control last
> modified:".
>
> Is it documented anywhere the difference between "pg_control last
> modified:" and "Time of latest checkpoint:" ?
If it's documented, I haven't found it yet. I generally find the
labels to be pretty descriptive, though.
"pg_control last modified" is the last time the server wrote control
information out to the disk. "Time of latest checkpoint" is the
last time a checkpoint had been performed at the point when the
control data was last written.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-01-31 18:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-01-27 20:04 Clarification of pg_cotroldata output Melvin Davidson <mdavidson@icsolutions.com>
2011-01-31 18:48 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox