aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor/nodeHashjoin.c
diff options
context:
space:
mode:
authorDavid Rowley <drowley@postgresql.org>2025-04-11 11:36:21 +1200
committerDavid Rowley <drowley@postgresql.org>2025-04-11 11:36:21 +1200
commit530050d8d2850d0453bb56e2bfa7cae216ee8a18 (patch)
tree769f97daa3d3c5c9484ea18c17d90f7ebf0bdc75 /src/backend/executor/nodeHashjoin.c
parent39729ec01d25dbe12e0dd8322c68f242650235c9 (diff)
downloadpostgresql-530050d8d2850d0453bb56e2bfa7cae216ee8a18.tar.gz
postgresql-530050d8d2850d0453bb56e2bfa7cae216ee8a18.zip
Add code comment explaining ins_since_vacuum and aborted inserts
Sami complained that there's a discrepancy between n_mod_since_analyze and n_ins_since_vacuum, as the former only accounts for committed changes and the latter tracks committed and aborted inserts. Nobody seemed overly concerned that this would cause any concerning issues. The repercussions, from what I can tell, are limited to causing an autovacuum to trigger for inserts sooner than it otherwise might. For typical ratios of commits to aborts, it's unlikely to ever be noticed. Fixing things to make it so n_ins_since_vacuum only displays committed inserts would require an additional field in PgStat_TableCounts, which does not quite seem worthwhile at this stage. This commit just adds a comment with some details to mention that we know about it, which will hopefully prevent repeat discussions. Reported-by: Sami Imseih <samimseih@gmail.com> Author: David Rowley <drowleyml@gmail.com> Reviewed-by: Sami Imseih <samimseih@gmail.com> Discussion: https://postgr.es/m/CAApHDvpgV3a-R2EGmPOh0L-x3pHbZpM3y4dySWfy+UqUazwDQA@mail.gmail.com
Diffstat (limited to 'src/backend/executor/nodeHashjoin.c')
0 files changed, 0 insertions, 0 deletions