PostgreSQL

Allow pg_partman background worker to optionally use new maintenance procedure

pg_partman's background worker currently uses the run_maintenance() function. PostgreSQL 11 introduced procedures which allows committing in batches within a single procedure call. A run_maintenance_proc() was added in version 4.0.0 of pg_partman, but the background worker does not use this yet. Implement a postgresql.conf configuration option (GUC) to allow the background worker to optionally use the new procedure if PG11 is in use.

Code still needs to be kept backward compatible with older versions of postgresql. Ensure this is done properly.

Either provide a Github pull request adding this feature or provide reasons why this new procedure may not work via the background worker.

Task tags

  • c-language
  • c
  • code
  • programming
  • sql

Students who completed this task

JackLiu

Task type

  • code Code
close

2018