Re: [HACKERS] Reporting xmin from VACUUMs

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: [HACKERS] Reporting xmin from VACUUMs
Дата
Msg-id CAD21AoAsibpq5Ro_wAzQzseftf26zpHDE84WP+yz9JL2Zes1fA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Reporting xmin from VACUUMs  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Sat, Feb 11, 2017 at 7:00 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Fri, Feb 10, 2017 at 3:30 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
>> We've added xmin info to pg_stat_activity and pg_stat_replication, but
>> VACUUM doesn't yet report which xmin value it used when it ran.
>>
>> Small patch to add this info to VACUUM output.

+1

> It seems sensible to me to do something like this.  We already report
> a lot of other fine details, so what's one more?  And it could be
> useful.

Also, I've been proposing to report the number of skipped the frozen
pages even in manual vacuum verbose log.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] contrib modules and relkind check
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] DROP SUBSCRIPTION and ROLLBACK