Re: parallel vacuum comments
Amit Kapila <amit.kapila16@gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
To: "houzj.fnst@fujitsu.com" <houzj.fnst@fujitsu.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>,
Peter Geoghegan <pg@bowt.ie>, Andres Freund <andres@anarazel.de>
Date: 2021-12-03T09:36:31Z
Lists: pgsql-hackers
On Fri, Dec 3, 2021 at 3:01 PM houzj.fnst@fujitsu.com <houzj.fnst@fujitsu.com> wrote: > > On Thur, Dec 2, 2021 8:31 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote: > > I've attached updated patches. > > > > The first patch is the main patch for refactoring parallel vacuum code; removes > > bitmap-related code and renames function names for consistency. The second > > patch moves these parallel-related codes to vacuumparallel.c as well as > > common functions that are used by both lazyvacuum.c and vacuumparallel.c to > > vacuum.c. The third patch adds regression tests for parallel vacuum on > > different kinds of indexes with multiple index scans. Please review them. > > Thanks for updating the patch. > I reviewed the 0001 patch and didn’t find some big issues in the patch. > > I only have a personally suggestion for the following function name: > > parallel_vacuum_process_unsafe_indexes > parallel_vacuum_index_is_parallel_safe > > It seems not only "unsafe" index are processed in the above functions, > but also index which is unsuitable(based on parallel_vacuum_should_skip_index). > I have given one comment to remove the call to parallel_vacuum_should_skip_index() from parallel_vacuum_index_is_parallel_safe(). If Sawada-San follows that then maybe your point will be addressed. -- With Regards, Amit Kapila.
Commits
-
Move parallel vacuum code to vacuumparallel.c.
- 8e1fae193864 15.0 landed
-
Move index vacuum routines to vacuum.c.
- cc8b25712b5e 15.0 landed
-
Improve parallel vacuum implementation.
- 22bd3cbe0c28 15.0 landed
-
Fix parallel amvacuumcleanup safety bug.
- c59278a1aa5e 15.0 landed
- f6162c020c88 14.1 landed
-
Simplify state managed by VACUUM.
- b4af70cb2103 14.0 cited