Forum Discussion

Shaban Khan's avatar
Shaban Khan
Copper Contributor
Sep 06, 2020

Any performance impact after enable Query Store feature in Azure PostgreSQL DB Server

Hi Team,

 

We want to enable Query store in Azure PostgreSQL DB server for Intelligent Performance (Query Performance Insight and Performance Recommendations) feature.

 

Before enable the feature, want to understand any performance impact on the PostgreSQL DB server if enable the feature.

 

Can you please share if you have any insight on the performance impact.

 

Thanks in advance.

 

Thanks

Shaban Khan

Azure Database for PostgreSQL

1 Reply

  • GrantFritchey's avatar
    GrantFritchey
    Copper Contributor
    May 31, 2022
    In the testing I've done, the impact is extremely minimal. However, don't trust me. Test it on your own system. The degree of impact is tied pretty tightly with the volume of queries on your system.

Resources