Re: [PROPOSAL] VACUUM Progress Checker.

From: <pokurev(at)pm(dot)nttdata(dot)co(dot)jp>
To: <robertmhaas(at)gmail(dot)com>, <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
Cc: <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>, <amitlangote09(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>, <bannos(at)nttdata(dot)co(dot)jp>
Subject: Re: [PROPOSAL] VACUUM Progress Checker.
Date: 2016-03-10 01:51:36
Message-ID: 8f95982489b849c7ae662f20e908ad52@MP-MSGSS-MBX007.msg.nttdata.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
Thank you very much for committing this feature.
> -----Original Message-----
> From: Robert Haas [mailto:robertmhaas(at)gmail(dot)com]
> Sent: Thursday, March 10, 2016 2:17 AM
> To: Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>
> Cc: Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>; Amit Langote
> <amitlangote09(at)gmail(dot)com>; SPS ポクレ ヴィナヤック(三技術)
> <pokurev(at)pm(dot)nttdata(dot)co(dot)jp>; pgsql-hackers(at)postgresql(dot)org; SPS 坂野 昌
> 平(三技術) <bannos(at)nttdata(dot)co(dot)jp>
> Subject: Re: [HACKERS] [PROPOSAL] VACUUM Progress Checker.
>
> On Wed, Mar 9, 2016 at 2:37 AM, Amit Langote
> <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> > On 2016/03/09 10:11, Amit Langote wrote:
> >> The attached revision addresses above and one of Horiguchi-san's
> >> comments in his email yesterday.
> >
> > I fixed one more issue in 0002 per Horiguchi-san's comment. Sorry
> > about so many versions.
>
> I've committed 0001 with heavy revisions. Just because we don't need an
> SQL-visible function to clear the command progress doesn't mean we don't
> need to clear it at all; rather, it has to happen automatically.
> I also did a bunch of identifier renaming, added datid to the view output,
> adjusted the comments, and so on. Please rebase the remainder of the
> series. Thanks.
Some minor typos need to fix.
+/*-----------
+ * pgstat_progress_start_command() -
+ *
+ * Set st_command in own backend entry. Also, zero-initialize
+ * st_progress_param array.
+ *-----------
+ */
In the description we need to use st_progress_command instead of st_command.

+/*-----------
+ * pgstat_progress_end_command() -
+ *
+ * Update index'th member in st_progress_param[] of own backend entry.
+ *-----------
+ */
Here also need to change the description.

Regards,
Vinayak Pokale

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2016-03-10 01:53:12 Re: Relation extension scalability
Previous Message Craig Ringer 2016-03-10 01:49:41 Re: Proposal: RETURNING primary_key()