Amazon Aurora PostgreSQL Query Plan Management

The quality and consistency of query optimization have a major impact on the performance and stability of any relational database management system (RDBMS). As conditions change, the optimizer might pick a different plan that makes performance worse.
In this video, learn how you can prevent SQL execution plan regressions in Amazon Aurora PostgreSQL when the database system or environment changes, and how you can control when and whether the optimizer can use new plans.
Learn more about Managing query execution plans for Aurora PostgreSQL at - amzn.to/3oxzb6C
Subscribe:
More AWS videos bit.ly/2O3zS75
More AWS events videos bit.ly/316g9t4
#AWS #AWSDemo

[@manmitsingh4958]

Amazing

[@user-ww3yy6mz9c]

good job~

[@haripapisetty]

Wow

[@bharathpr]

Is there any mechanism to alert, if the plan changes for a querty

[@rlsusan]

Hello, our team is facing challenge with queries from application not using the managed plan. The query executed in backend uses managed plan. Our application is written in Java wity custom query written as prepared statement. Does anyone have any lead on this issue. Also, support says that application connection caches plan and hence uses bad plan, which is hard to understand

[@bharathpr]

Nice, could you pls share how pg_bench data is loaded in ApG

[@peppigue]

Well, well... This could have been better.