AZ479194 - Generally Available: Azure Database for PostgreSQL pg_signal_autovaccum_worker role

You can now use the pg_signal_autovacuum_worker role backported from PostgreSQL version 18 with Azure Database for PostgreSQL Flexible Server versions 15 and later. The autovacuum process, once it is triggered, blocks the execution of DDL statements until the time it gets executed. This role allows you to cancel the autovacuum process that gets triggered as part of maintenance activity on the PostgreSQL server using pg_terminate_backend()/pg_cancel_backend() statements. This is a significant improvement as it allows users with non-superuser privileges to cancel the autovacuum process.   

Learn more.