Does anyone can share tips for improving performance for Information Links getting data from a PostgreSql Data Source?


I have some small tables (about 3 million tuples) that are being pulled from a Postgresql server using a data source. Sometimes the dashboard seems to struglle getting those tables, so I was wondering if there are something that I can do to improve the loading. I have created indexes for all tables and check the query using EXPLAIN ANALYZE. All seems to be okay.

I seen options in Data Source, such as [Fetch Size] and [Batch size] both of them I have leaved untouched (10000 and 100) on my configuration. Can I use this to make some tunning on the Data Source?

I would appreciate any tip related to this matter.






Image icon datasource.png17.36 KB

(1) Answer