Re: n_ins_since_vacuum stats for aborted transactions - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: n_ins_since_vacuum stats for aborted transactions
Date
Msg-id CAKFQuwZDczMixPmZwoxrWabJCTK2ZMSetNcFz93peNYuko23Kg@mail.gmail.com
Whole thread Raw
In response to Re: n_ins_since_vacuum stats for aborted transactions  (Sami Imseih <samimseih@gmail.com>)
List pgsql-hackers
On Wed, Apr 9, 2025, 12:39 Sami Imseih <samimseih@gmail.com> wrote:

They will differ because n_tup_ins keeps increasing, while n_ins_since_vacuum is
reset after a vacuum. The issue I see is that n_ins_since_vacuum should only
reflect the number of newly inserted rows that are eligible for
freezing, as described
in pgstat_report_vacuum [0]

Vacuuming them into oblivion is a form of freezing.  It also removes the aging xid from the table.

David J.

pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: n_ins_since_vacuum stats for aborted transactions
Next
From: Sami Imseih
Date:
Subject: Re: n_ins_since_vacuum stats for aborted transactions