pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix vacuum_cost_delay check for balance calculation. 6+ messages / 1 participants [nested] [flat]
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 11:58 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 11:58 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/bfac8f8bc4a44c67c9f35b5266676278e4ba1217 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 11:59 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 11:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0319b306e87e04a02b672b38caf578859fcea6a3 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 11:59 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 11:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0e8e5e856cc37cfcd8ac458dddd71f89d516fc27 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 11:59 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 11:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/b95f36f8613166171f221ef5f4cd6fb583605c91 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 11:59 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 11:59 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/cba3c8f6dd7fffb63eac2f31d98bd23816959d04 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Fix vacuum_cost_delay check for balance calculation. @ 2023-04-25 12:00 Daniel Gustafsson <dgustafsson@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Daniel Gustafsson @ 2023-04-25 12:00 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Fix vacuum_cost_delay check for balance calculation. Commit 1021bd6a89 excluded autovacuum workers from cost-limit balance calculations when per-relation options were set. The code checks for limit and cost_delay being greater than zero, but since cost_delay can be set to -1 the test needs to check for greater than or zero. Backpatch to all supported branches since 1021bd6a89 was backpatched all the way at the time. Author: Masahiko Sawada <sawada.mshk@gmail.com> Reviewed-by: Melanie Plageman <melanieplageman@gmail.com> Reviewed-by: Daniel Gustafsson <daniel@yesql.se> Discussion: https://postgr.es/m/CAD21AoBS7o6Ljt_vfqPQPf67AhzKu3fR0iqk8B=vVYczMugKMQ@mail.gmail.com Backpatch-through: v11 (all supported branches) Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0151d2c5f256063c6143778062d4685bb08b2db7 Modified Files -------------- src/backend/postmaster/autovacuum.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-04-25 12:00 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-04-25 11:58 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@postgresql.org> 2023-04-25 11:59 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@postgresql.org> 2023-04-25 11:59 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@postgresql.org> 2023-04-25 11:59 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@postgresql.org> 2023-04-25 11:59 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@postgresql.org> 2023-04-25 12:00 pgsql: Fix vacuum_cost_delay check for balance calculation. Daniel Gustafsson <dgustafsson@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