agora inbox for pgsql-committers@postgresql.orghelp / color / mirror / Atom feed
pgsql: Flush statistics during idle periods in parallel apply worker. 4+ messages / 1 participants [nested] [flat]
* pgsql: Flush statistics during idle periods in parallel apply worker. @ 2026-04-20 05:07 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Amit Kapila @ 2026-04-20 05:07 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Flush statistics during idle periods in parallel apply worker. Parallel apply workers previously failed to report statistics while waiting for new work in the main loop. This resulted in the stats from the most recent transaction remaining unbuffered, leading to arbitrary reporting delays—particularly when streamed transactions were infrequent. This commit ensures that statistics are explicitly flushed when the worker is idle, providing timely visibility into accumulated worker activity. Author: Zhijie Hou <houzj.fnst@fujitsu.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Backpatch-through: 16, where it was introduced Discussion: https://postgr.es/m/TYRPR01MB1419579F217CC4332B615589594202@TYRPR01MB14195.jpnprd01.prod.outlook.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/090c4297e40977bc35e59faeb0a003561a4a5c7c Modified Files -------------- src/backend/replication/logical/applyparallelworker.c | 9 +++++++++ 1 file changed, 9 insertions(+) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Flush statistics during idle periods in parallel apply worker. @ 2026-04-20 05:07 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Amit Kapila @ 2026-04-20 05:07 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Flush statistics during idle periods in parallel apply worker. Parallel apply workers previously failed to report statistics while waiting for new work in the main loop. This resulted in the stats from the most recent transaction remaining unbuffered, leading to arbitrary reporting delays—particularly when streamed transactions were infrequent. This commit ensures that statistics are explicitly flushed when the worker is idle, providing timely visibility into accumulated worker activity. Author: Zhijie Hou <houzj.fnst@fujitsu.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Backpatch-through: 16, where it was introduced Discussion: https://postgr.es/m/TYRPR01MB1419579F217CC4332B615589594202@TYRPR01MB14195.jpnprd01.prod.outlook.com Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/44c8dc28017800892adbdc7f248f6bed5aa90bef Modified Files -------------- src/backend/replication/logical/applyparallelworker.c | 9 +++++++++ 1 file changed, 9 insertions(+) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Flush statistics during idle periods in parallel apply worker. @ 2026-04-20 05:07 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Amit Kapila @ 2026-04-20 05:07 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Flush statistics during idle periods in parallel apply worker. Parallel apply workers previously failed to report statistics while waiting for new work in the main loop. This resulted in the stats from the most recent transaction remaining unbuffered, leading to arbitrary reporting delays—particularly when streamed transactions were infrequent. This commit ensures that statistics are explicitly flushed when the worker is idle, providing timely visibility into accumulated worker activity. Author: Zhijie Hou <houzj.fnst@fujitsu.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Backpatch-through: 16, where it was introduced Discussion: https://postgr.es/m/TYRPR01MB1419579F217CC4332B615589594202@TYRPR01MB14195.jpnprd01.prod.outlook.com Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/88d7fdcc9aaa065daf10ff3b777f607fe65bdc02 Modified Files -------------- src/backend/replication/logical/applyparallelworker.c | 9 +++++++++ 1 file changed, 9 insertions(+) ^ permalink raw reply [nested|flat] 4+ messages in thread
* pgsql: Flush statistics during idle periods in parallel apply worker. @ 2026-04-20 05:07 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 4+ messages in thread From: Amit Kapila @ 2026-04-20 05:07 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Flush statistics during idle periods in parallel apply worker. Parallel apply workers previously failed to report statistics while waiting for new work in the main loop. This resulted in the stats from the most recent transaction remaining unbuffered, leading to arbitrary reporting delays—particularly when streamed transactions were infrequent. This commit ensures that statistics are explicitly flushed when the worker is idle, providing timely visibility into accumulated worker activity. Author: Zhijie Hou <houzj.fnst@fujitsu.com> Reviewed-by: Chao Li <li.evan.chao@gmail.com> Reviewed-by: Amit Kapila <amit.kapila16@gmail.com> Backpatch-through: 16, where it was introduced Discussion: https://postgr.es/m/TYRPR01MB1419579F217CC4332B615589594202@TYRPR01MB14195.jpnprd01.prod.outlook.com Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d052f6c7d97fae1e5ecee74981fbcbba0f168a7d Modified Files -------------- src/backend/replication/logical/applyparallelworker.c | 9 +++++++++ 1 file changed, 9 insertions(+) ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2026-04-20 05:07 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-04-20 05:07 pgsql: Flush statistics during idle periods in parallel apply worker. Amit Kapila <akapila@postgresql.org> 2026-04-20 05:07 pgsql: Flush statistics during idle periods in parallel apply worker. Amit Kapila <akapila@postgresql.org> 2026-04-20 05:07 pgsql: Flush statistics during idle periods in parallel apply worker. Amit Kapila <akapila@postgresql.org> 2026-04-20 05:07 pgsql: Flush statistics during idle periods in parallel apply worker. Amit Kapila <akapila@postgresql.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox