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.