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

pgsql: Allow vacuum command to process indexes in parallel.

2020-01-19 Thread Amit Kapila
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 adds a PARALLEL option to VACUUM command where the user can specif