On Thu, 23 Jan 2020 at 15:32, Mahendra Singh Thalor <mahi6...@gmail.com> wrote: > > On Wed, 22 Jan 2020 at 12:48, Masahiko Sawada > <masahiko.saw...@2ndquadrant.com> wrote: > > > > On Wed, 22 Jan 2020 at 11:23, Amit Kapila <amit.kapil...@gmail.com> wrote: > > > > > > On Wed, Jan 22, 2020 at 7:14 AM Masahiko Sawada > > > <masahiko.saw...@2ndquadrant.com> wrote: > > > > > > > > Thank you for updating the patch. Yeah MAXDEADTUPLES is better than > > > > what I did in the previous version patch. > > > > > > > > > > Would you like to resubmit your vacuumdb utility patch for this > > > enhancement? I see some old version of it and it seems to me that you > > > need to update that patch. > > > > > > + if (optarg != NULL) > > > + { > > > + parallel_workers = atoi(optarg); > > > + if (parallel_workers <= 0) > > > + { > > > + pg_log_error("number of parallel workers must be at least 1"); > > > + exit(1); > > > + } > > > + } > > > > > > This will no longer be true. > > > > Attached the updated version patch. > > > > Thanks Sawada-san for the re-based patch. > > I reviewed and tested this patch. Patch looks good to me.
As offline, suggested by Amit Kapila, I verified vacuumdb "-P" option functionality with older versions(<13) and also I tested vacuumdb by giving "-j" option with "-P". All are working as per expectation and I didn't find any issue with these options. -- Thanks and Regards Mahendra Singh Thalor EnterpriseDB: http://www.enterprisedb.com