This is based on the Version 8 release of the pg_gather project.
Upto 20% space saving in the output file. Redirects unnecessary output to null device wherever possible
Improvements to gather.sql for scheduling it against template1 database for partial data gathering. which works as simple continuous monitoring.
New history schema and history import script
Multiple Improvements to the bulk import of partial data to history tables. New sed script extracts the COPY commands and feeds the psql. Method of CTEs and bulk updates are avoided.
All tables are converted into UNLOGGED because the data is temporary in nature. Improves the speed especially when PostgreSQL runs in small VMs / containers.
Improvements to README based on feedback. New sections for Partial data collection and importing data.
Cleanup/remove pg_get_wait which is no longer used.
Improvement to analytical query and gather_old.sql patched for latest schema
This is based on the Version 8 release of the pg_gather project.
gather.sqlfor scheduling it againsttemplate1database for partial data gathering. which works as simple continuous monitoring.