Re: [PATCH] vacuumlo: print the number of large objects going to beremoved - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] vacuumlo: print the number of large objects going to beremoved
Date
Msg-id 20190613061115.GD1643@paquier.xyz
Whole thread Raw
In response to Re: [PATCH] vacuumlo: print the number of large objects going to be removed  (Timur Birsh <taem@linukz.org>)
Responses Re: [PATCH] vacuumlo: print the number of large objects going to be removed
List pgsql-hackers
Hi,

On Thu, Jun 13, 2019 at 10:49:46AM +0600, Timur Birsh wrote:
> 12.06.2019, 14:31, "Timur Birsh" <taem@linukz.org>:
>> Please cc, I am not subscribed to the list.
>
> I have subscribed to the mailing list, there is no need to cc me.

Welcome.  Nice to see that you have subscribed to the lists.

Please note that we have some guidelines regarding the way patches are
submitted:
https://wiki.postgresql.org/wiki/Submitting_a_Patch
Based on what I can see with your patch, things are in good shape on
this side.

Now, if you want to get review for your patch, you should register it
in what we call the commit fest app, which is here:
https://commitfest.postgresql.org/23/

Commit fests happen every two months for a duration of one month, and
the next one which will begin the development cycle of v13 begins on
the 1st of July.  As a basic rule, it is expected that for one patch
submitted, you should review another patch of equal difficulty to keep
some balance in the force.

Regarding the patch, there is an argument to be made for reporting a
rate as well as the actual numbers of deleted and to-delete items.

+       if (param->verbose)
+       {
+               snprintf(buf, BUFSIZE, "SELECT count(*) FROM vacuum_l");
+               res = PQexec(conn, buf);
That part is costly.

Thanks!
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Race conditions with checkpointer and shutdown
Next
From: Michael Paquier
Date:
Subject: Re: PG 12 draft release notes