On 11 September 2015 at 15:43, Syed, Rahila <rahila.s...@nttdata.com> wrote:
> > Hello, > > Please find attached updated VACUUM progress checker patch. > Following have been accomplished in the patch > > 1. Accounts for index pages count while calculating total progress of > VACUUM. > 2. Common location for storing progress parameters for any command. Idea > is every command which needs to report progress can populate and interpret > the shared variables in its own way. > Each can display progress by implementing separate views. > 3. Separate VACUUM progress view to display various progress parameters > has been implemented . Progress of various phases like heap scan, index > scan, total pages scanned along with > completion percentage is reported. > 4.This view can display progress for all active backends running VACUUM. > > Basic testing has been performed. Thorough testing is yet to be done. > Marking it as Needs Review in Sept-Commitfest. > > ToDo: > Display count of heap pages actually vacuumed(marking line pointers unused) > Display percentage of work_mem being used to store dead tuples. > > Thank you, > Rahila Syed > This doesn't seem to compile: make[4]: Leaving directory `/home/thom/Development/postgresql/src/backend' make[3]: Leaving directory `/home/thom/Development/postgresql/src/common' make -C catalog schemapg.h make[3]: Entering directory `/home/thom/Development/postgresql/src/backend/catalog' cd ../../../src/include/catalog && '/usr/bin/perl' ./duplicate_oids 3308 make[3]: *** [postgres.bki] Error 1 make[3]: Leaving directory `/home/thom/Development/postgresql/src/backend/catalog' make[2]: *** [submake-schemapg] Error 2 make[2]: Leaving directory `/home/thom/Development/postgresql/src/backend' make[1]: *** [install-backend-recurse] Error 2 make[1]: Leaving directory `/home/thom/Development/postgresql/src' make: *** [install-src-recurse] Error 2 make: Leaving directory `/home/thom/Development/postgresql' Thom