Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Peter Geoghegan <pg(at)bowt(dot)ie>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)
Date: 2022-09-01 02:49:13
Message-ID: CAMkU=1ybGMREF8oyA7oqv4_+Z4V747yePYbTVnS28DYq=Cqh5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Aug 20, 2022 at 7:29 PM Peter Geoghegan <pg(at)bowt(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2022-09-01 03:08:04 Re: pg15b3: recovery fails with wal prefetch enabled
Previous Message Kyotaro Horiguchi 2022-09-01 02:48:40 Re: Add the ability to limit the amount of memory that can be allocated to backends.