pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode. 2+ messages / 1 participants [nested] [flat]
* pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode. @ 2023-02-06 16:01 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Robert Haas @ 2023-02-06 16:01 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Disable STARTUP_PROGRESS_TIMEOUT in standby mode. In standby mode, we don't actually report progress of recovery, but up until now, startup_progress_timeout_handler() nevertheless got called every log_startup_progress_interval seconds. That's an unnecessary expense, so avoid it. Report by Thomas Munro. Patch by Bharath Rupireddy, reviewed by Simon Riggs, Thomas Munro, and me. Back-patch to v15, where the problem was introduced. Discussion: https://www.postgresql.org/message-id/CA%2BhUKGKCHSffAj8zZJKJvNX7ygnQFxVD6wm1d-2j3fVw%2BMafPQ%40mail... Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/8a2f783cc489e4e1820163c1c439125aad4d7a92 Modified Files -------------- src/backend/access/transam/xlogrecovery.c | 25 ++++++++++++++++++++++--- src/backend/postmaster/startup.c | 30 +++++++++++++++++++++++++++--- src/include/postmaster/startup.h | 2 ++ 3 files changed, 51 insertions(+), 6 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode. @ 2023-02-06 16:01 Robert Haas <rhaas@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Robert Haas @ 2023-02-06 16:01 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Disable STARTUP_PROGRESS_TIMEOUT in standby mode. In standby mode, we don't actually report progress of recovery, but up until now, startup_progress_timeout_handler() nevertheless got called every log_startup_progress_interval seconds. That's an unnecessary expense, so avoid it. Report by Thomas Munro. Patch by Bharath Rupireddy, reviewed by Simon Riggs, Thomas Munro, and me. Back-patch to v15, where the problem was introduced. Discussion: https://www.postgresql.org/message-id/CA%2BhUKGKCHSffAj8zZJKJvNX7ygnQFxVD6wm1d-2j3fVw%2BMafPQ%40mail... Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/98e7234242a652497c99d4d0d6f2bf9a75d4e921 Modified Files -------------- src/backend/access/transam/xlogrecovery.c | 25 ++++++++++++++++++++++--- src/backend/postmaster/startup.c | 30 +++++++++++++++++++++++++++--- src/include/postmaster/startup.h | 2 ++ 3 files changed, 51 insertions(+), 6 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-02-06 16:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-02-06 16:01 pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode. Robert Haas <rhaas@postgresql.org> 2023-02-06 16:01 pgsql: Disable STARTUP_PROGRESS_TIMEOUT in standby mode. Robert Haas <rhaas@postgresql.org>
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