I am trying to fetch 300k records from Predix Postgres to Predix microservice. The data size is roughly around 50 MB and the Data transfer is talking around 40 seconds. Why is this so slow? I am under the assumption that it would be a local network transfer through the same VPC and local subnet.
Can some configuration be changed at Postgres or somewhere else to improve the data transfer?
Another question, what should be the maximum number of records/size to not have bad performance?
Note: I have Already used optimized query and only fetching required columns.
@Siva Balan @Sergey Vyatkin