Re: [PROPOSAL] VACUUM Progress Checker. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [PROPOSAL] VACUUM Progress Checker.
Date
Msg-id CA+TgmoYv60+sqTT2aCu418Vczehh3Zy0jVcOSOcP7Q4Hp08f2A@mail.gmail.com
Whole thread Raw
In response to Re: [PROPOSAL] VACUUM Progress Checker.  ("Syed, Rahila" <Rahila.Syed@nttdata.com>)
List pgsql-hackers
On Tue, Oct 20, 2015 at 4:58 AM, Syed, Rahila <Rahila.Syed@nttdata.com> wrote:
>>I think that you should add the flag or something which indicates whether this backend is running VACUUM or not, into
PgBackendStatus.
>>pg_stat_vacuum_progress should display the entries of only backends with that flag set true. This design means that
youneed to set the flag to true when starting VACUUM and reset at the end of VACUUM progressing.
 
> Please find attached  updated patch which adds a flag in PgBackendStatus which indicates whether this backend in
runningVACUUM.
 

Flag isn't reset on error.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Checkpoint throttling issues
Next
From: Robbie Harwood
Date:
Subject: Re: [PATCH v3] GSSAPI encryption support