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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)
Дата
Msg-id CAMkU=1ybGMREF8oyA7oqv4_+Z4V747yePYbTVnS28DYq=Cqh5g@mail.gmail.com
обсуждение исходный текст
Ответ на Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)  (Peter Geoghegan <pg@bowt.ie>)
Re: Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE)  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Add the ability to limit the amount of memory that can be allocated to backends.
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: pg15b3: recovery fails with wal prefetch enabled