Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-04-01 Thread Amit Kapila
On Wed, Apr 1, 2020 at 8:39 AM Mahendra Singh Thalor wrote: > > On Tue, 31 Mar 2020 at 17:28, Amit Kapila wrote: > > > > On Mon, Mar 30, 2020 at 8:30 AM Mahendra Singh Thalor > > wrote: > > > > > > > > > 2077 if ((shared_balance >= VacuumCostLimit) && > > > > > > >>> CID ...: Incor

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-31 Thread Mahendra Singh Thalor
On Tue, 31 Mar 2020 at 17:28, Amit Kapila wrote: > > On Mon, Mar 30, 2020 at 8:30 AM Mahendra Singh Thalor > wrote: > > > > > > > 2077 if ((shared_balance >= VacuumCostLimit) && > > > > > >>> CID ...: Incorrect expression (UNINTENDED_INTEGER_DIVISION) > > > > > >>> Dividing int

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-31 Thread Amit Kapila
On Mon, Mar 30, 2020 at 8:30 AM Mahendra Singh Thalor wrote: > > > > > 2077 if ((shared_balance >= VacuumCostLimit) && > > > > >>> CID ...: Incorrect expression (UNINTENDED_INTEGER_DIVISION) > > > > >>> Dividing integer expressions "VacuumCostLimit" and "nworkers", > > > > >>>

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-31 Thread Andres Freund
Hi, On March 31, 2020 12:43:47 AM PDT, Mahendra Singh Thalor wrote: >On Mon, 30 Mar 2020 at 09:44, Amit Kapila >wrote: >> >> On Mon, Mar 30, 2020 at 4:18 AM Andres Freund >wrote: >> > >> > > 2076 >> > > 2077 if ((shared_balance >= VacuumCostLimit) && >> > > >>> CID ...: Incorrec

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-31 Thread Mahendra Singh Thalor
On Mon, 30 Mar 2020 at 09:44, Amit Kapila wrote: > > On Mon, Mar 30, 2020 at 4:18 AM Andres Freund wrote: > > > > > 2076 > > > 2077 if ((shared_balance >= VacuumCostLimit) && > > > >>> CID ...: Incorrect expression (UNINTENDED_INTEGER_DIVISION) > > > >>> Dividing integer expres

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-29 Thread Amit Kapila
On Mon, Mar 30, 2020 at 4:18 AM Andres Freund wrote: > > > 2076 > > 2077 if ((shared_balance >= VacuumCostLimit) && > > >>> CID ...: Incorrect expression (UNINTENDED_INTEGER_DIVISION) > > >>> Dividing integer expressions "VacuumCostLimit" and "nworkers", and > > >>> then conver

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-29 Thread Mahendra Singh Thalor
On Mon, 30 Mar 2020 at 07:39, Amit Kapila wrote: > > On Mon, Mar 30, 2020 at 4:18 AM Andres Freund wrote: > > > > Hi, > > > > On 2020-01-20 02:33:34 +, Amit Kapila wrote: > > > Allow vacuum command to process indexes in parallel. > > > > > > This feature allows the vacuum to leverage multiple

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-29 Thread Amit Kapila
On Mon, Mar 30, 2020 at 4:18 AM Andres Freund wrote: > > Hi, > > On 2020-01-20 02:33:34 +, Amit Kapila wrote: > > Allow vacuum command to process indexes in parallel. > > > > This feature allows the vacuum to leverage multiple CPUs in order to > > process indexes. This enables us to perform i

Re: pgsql: Allow vacuum command to process indexes in parallel.

2020-03-29 Thread Andres Freund
Hi, On 2020-01-20 02:33:34 +, Amit Kapila wrote: > Allow vacuum command to process indexes in parallel. > > This feature allows the vacuum to leverage multiple CPUs in order to > process indexes. This enables us to perform index vacuuming and index > cleanup with background workers. This ad