PostgreSQL Profile Manager: Adaptive Workload Control

PostgreSQL Profile Manager is a proposal to make Postgres workload-aware with switchable runtime profiles. Extensions like pg_psi - which integrates cgroup and Linux PSI - show how profiles can adapt resources, tune configs, and cut cloud costs seamlessly.

PostgreSQL Profile Manager is a proposal to bring adaptive workload management into Postgres.
Instead of static configs or manual tuning, it introduces runtime profiles: reusable sets of parameters and extension hooks that can be switched as workloads evolve.

With Profile Manager, Postgres can adapt seamlessly between OLTP, analytics, or custom extensions, while also controlling resources in cloud environments to reduce costs.

An example extension is pg_psi, which leverages cgroup and Linux PSI to monitor and react to system pressure — showing how extensions can integrate with profiles to make Postgres workload-aware and resource-efficient.

Proposal to get Profile Manager in PostgreSQL to get a syntax similar to FDW Servers:

```{.sql} CREATE EXTENSION pg_psi;

SET log_min_messages TO NOTICE; SET search_path TO public,profile_manager;

SELECT create_manager( manager_name => ‘cgroup’ , handler_function => ‘profile_manager.cgroup_pm_handler’ , options => ARRAY[‘debug’,’true’] , comment => ‘create manager’ ); SELECT create_profile( profile_name => ‘/critical/wal_senders’ , profile_manager => ‘cgroup’ , profile_config => ‘{“path”: “/critical/wal_senders”, “tuning”:{}, “trigger”:{“cpu.pressure”:”some 50000 2000000”}}’ ); SELECT create_scope( scope_name => ‘/critical/wal_senders’ , scope_profile_name => ‘/critical/wal_senders’ , scope_backend_type => ‘walsender’ ); … ```