Remove 2029 Remove Speed Remove Storage Remove Systems
article thumbnail

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

Percona

You can set the parameter either by using ALTER SYSTEM or by manually modifying the config file. partman=# ALTER SYSTEM set shared_preload_libraries = 'pg_partman_bgw'; ALTER SYSTEM Afterward, perform a restart of the cluster either using systemctl or pg_ctl.

Storage 97