Re: pgsql: Allow vacuums to report oldestxmin

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-committers(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Allow vacuums to report oldestxmin
Date: 2017-03-06 12:37:58
Message-ID: CAD21AoAGA2pB3p-CWmTkxBsbkZS1bcDGBLcYVcvcDxspG_XAfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Fri, Mar 3, 2017 at 10:50 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> Allow vacuums to report oldestxmin
>
> Allow VACUUM and Autovacuum to report the oldestxmin value they
> used while cleaning tables, helping to make better sense out of
> the other statistics we report in various cases.
>
> Branch
> ------
> master
>
> Details
> -------
> http://git.postgresql.org/pg/commitdiff/9eb344faf54a849898d9be012ddfa8204cfeb57c
>
> Modified Files
> --------------
> src/backend/commands/vacuumlazy.c | 9 +++++----
> 1 file changed, 5 insertions(+), 4 deletions(-)
>
>

Should we change the example in vacuum.sgml file as well? Attached patch.

Regards,

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

Attachment Content-Type Size
fix_vacuum_example_in_doc.patch application/octet-stream 645 bytes

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2017-03-06 13:21:06 Re: pgsql: Notify bgworker registrant after freeing worker slot.
Previous Message Simon Riggs 2017-03-06 11:21:42 pgsql: Enhance docs for ALTER TABLE lock levels of storage parms

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-03-06 12:38:44 Re: PATCH: Configurable file mode mask
Previous Message Peter Eisentraut 2017-03-06 12:30:16 Re: objsubid vs subobjid