Azure Database for PostgreSQL - Known issues and limitations
APPLIES TO: Azure Database for PostgreSQL - Single Server
Important
Azure Database for PostgreSQL - Single Server is on the retirement path. We strongly recommend that you upgrade to Azure Database for PostgreSQL - Flexible Server. For more information about migrating to Azure Database for PostgreSQL - Flexible Server, see What's happening to Azure Database for PostgreSQL Single Server?.
This page provides a list of known issues in Azure Database for PostgreSQL that could impact your application. It also lists any mitigation and recommendations to work around the issue.
Intelligent Performance - Query Store
Applicable to Azure Database for PostgreSQL - Single Server.
Applicable | Cause | Remediation |
---|---|---|
PostgreSQL 9.6, 10, 11 | Turning on the server parameter pg_qs.replace_parameter_placeholders might lead to a server shutdown in some rare scenarios. |
Through Azure Portal, Server Parameters section, turn the parameter pg_qs.replace_parameter_placeholders value to OFF and save. |
Next steps
- See Query Store best practices