AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.
What should be checked when changing value of track_activity_query_size parameter?
When using Aurora PostgreSQL, to show the full text of SQL queries on the Performance Insights, a customer plans to change value of track_activity_query_size from 4kb (default) to 20kb. But, the customer is concerned that this change could cause performance issue and they want to know what points they should check after changing this parameter (e.g. CPU usage rate, disk I/O rate, cache hit rate, etc.). If you have any suggestion or idea, could you advise me?
- Etiquetas
- Aurora PostgreSQLAmazon Aurora
- Idioma
- English
- Más nuevo
- Más votos
- Más comentarios
Since the full SQL statements are cached in memory, memory usage may increase and affect the cache hit rate. As documented below, pg_stat_statements.max * track_activity_query_size bytes additional shared memory is required.
https://www.postgresql.jp/document/9.0/html/pgstatstatements.html
You may have to check the change in cache hit rate of the database and monitor for increasing wait events using RDS Performance Insights.
Contenido relevante
- preguntada hace 5 meses
- preguntada hace 10 días
- preguntada hace un mes
- preguntada hace un mes
