pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Clear 'xid' in dummy async notify entries written to fill up pag 6+ messages / 1 participants [nested] [flat]
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0e8eaa2181d477cc739e462295d344db750674e4 Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ REL_18_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/82fa6b78dba1037a8822ea5fae1018376c10fd3c Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/21a9014cf00ab370d7065a7184c1a087bc228b54 Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/0bdc777e80071abd77674f1e66258d410a010aa9 Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ REL_17_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/d80d5f09950281c6b852f8d121955bfa182ae539 Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgsql: Clear 'xid' in dummy async notify entries written to fill up pag @ 2025-11-12 19:34 Heikki Linnakangas <heikki.linnakangas@iki.fi> 0 siblings, 0 replies; 6+ messages in thread From: Heikki Linnakangas @ 2025-11-12 19:34 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org Clear 'xid' in dummy async notify entries written to fill up pages Before we started to freeze async notify entries (commit 8eeb4a0f7c), no one looked at the 'xid' on an entry with invalid 'dboid'. But now we might actually need to freeze it later. Initialize them with InvalidTransactionId to begin with, to avoid that work later. Álvaro pointed this out in review of commit 8eeb4a0f7c, but I forgot to include this change there. Author: Álvaro Herrera <alvherre@kurilemu.de> Discussion: https://www.postgresql.org/message-id/202511071410.52ll56eyixx7@alvherre.pgsql Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/84f1bf4afa5e7c329ca4dd908334205f8282c398 Modified Files -------------- src/backend/commands/async.c | 1 + 1 file changed, 1 insertion(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2025-11-12 19:34 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi> 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi> 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi> 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi> 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi> 2025-11-12 19:34 pgsql: Clear 'xid' in dummy async notify entries written to fill up pag Heikki Linnakangas <heikki.linnakangas@iki.fi>
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