Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.
Read OriginalA new PostgreSQL 18 feature introduces autovacuum_worker_slots, a parameter set at startup, enabling autovacuum_max_workers to be changed via SIGHUP reload. This allows DBAs to scale autovacuum activity up or down (e.g., during off-peak hours) without restarting the database server, offering greater operational control and optimization.
Comments
No comments yet
Be the first to share your thoughts!
Browser Extension
Get instant access to AllDevBlogs from your browser
Top of the Week
No top articles yet