Postgres Pro
Downloads
Home   >   mailing lists

Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE) - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)
Date
Msg-id CAMkU=1ybGMREF8oyA7oqv4_+Z4V747yePYbTVnS28DYq=Cqh5g@mail.gmail.com
Whole thread Raw
In response to Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)
Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)
List pgsql-hackers
Tree view
On Sat, Aug 20, 2022 at 7:29 PM Peter Geoghegan <pg@bowt.ie> wrote:
 
XIDs processed: 45 pages from table (100.00% of total) had 10000 tuples frozen

I like this addition, but I would also like to see how many pages got newly set to all frozen by the vacuum.  Would that be a convenient thing to also report here?

Also, isn't all of vacuuming about XID processing?  I think "frozen:" would be a more suitable line prefix.

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Add the ability to limit the amount of memory that can be allocated to backends.
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: pg15b3: recovery fails with wal prefetch enabled