Hello, we have a dashboard that has a few KPI widg...
# gooddata-cloud
m
Hello, we have a dashboard that has a few KPI widgets that all read from the same tables/views. Independently, each of the widgets loads quickly. However, when loaded together in a dashboard, they are slow. In AWS's RDS Performance Insights view, we can see that there is a lot of
LWLock::BufferIO
time -- i.e. the queries are blocked waiting on each other. We're wondering if the GoodData team has any recommendations on how to address this issue? Is there a way to limit concurrent sessions to a Postgres data source, for example? Some other suggestion? Thank you.
j
HI Michael, you can find some performance tips on optimizing your database for better performance HERE