Generally Available: PostgreSQL 17 performance management server parameters now modifiable on Azure Database for PostgreSQL

We are excited to announce that several parameters in Azure Database for PostgreSQL 17 can now be modified. This enhancement provides greater flexibility and control over your database configurations, allowing you to optimize performance and tailor settings to meet your specific needs. 

You can now modify the following parameters: 

• commit_timestamp_buffers: Adjust the number of buffers allocated for commit timestamps. 

• enable_parallel_append: Enable or disable parallel append operations. 

• event_triggers: Configure event triggers for specific database events. 

• multixact_member_buffers: Set the number of buffers for multi-transaction members. 

• multixact_offset_buffers: Define the number of buffers for multi-transaction offsets. 

• notify_buffers: Manage the buffers used for notifications. 

• serializable_buffers: Control the buffers allocated for serializable transactions. 

• subtransaction_buffers: Adjust the buffers for subtransactions. 

• transaction_buffers: Set the number of buffers for transactions. 

• plan_cache_mode: Configure the caching mode for query plans. 

Learn more.