Re: pgsql: Allow vacuum command to process indexes in parallel. - Mailing list pgsql-committers

From Mahendra Singh Thalor
Subject Re: pgsql: Allow vacuum command to process indexes in parallel.
Date
Msg-id CAKYtNAqG3NBMZqBX2izSkAfWGWsdXCnV-yedzyABcxBL21F-iw@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Allow vacuum command to process indexes in parallel.  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: pgsql: Allow vacuum command to process indexes in parallel.  (Andres Freund <andres@anarazel.de>)
List pgsql-committers
On Mon, 30 Mar 2020 at 09:44, Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Mon, Mar 30, 2020 at 4:18 AM Andres Freund <andres@anarazel.de> wrote:
> >
> > > 2076
> > > 2077          if ((shared_balance >= VacuumCostLimit) &&
> > > >>>     CID ...:  Incorrect expression  (UNINTENDED_INTEGER_DIVISION)
> > > >>>     Dividing integer expressions "VacuumCostLimit" and "nworkers", and then converting the integer quotient
totype "double". Any remainder, or fractional part of the quotient, is ignored.
 
> > > 2078                  (VacuumCostBalanceLocal > 0.5 * (VacuumCostLimit / nworkers)))
> > > 2079          {
> > > 2080                  /* Compute sleep time based on the local cost balance */
> > > 2081                  msec = VacuumCostDelay * VacuumCostBalanceLocal / VacuumCostLimit;
> > > 2082                  pg_atomic_sub_fetch_u32(VacuumSharedCostBalance, VacuumCostBalanceLocal);
> > > 2083                  VacuumCostBalanceLocal = 0;
> >
> > Which seems like a fair enough complaint?
> >
>
> Yeah, how can we set up and test a fix for this?  Where can I see these results?

I am able to make coverity setup.  I am verifying fix and will post my
results in coming days.

-- 
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com



pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Fix INSERT OVERRIDING USER VALUE behavior
Next
From: Andres Freund
Date:
Subject: Re: pgsql: Allow vacuum command to process indexes in parallel.