Predix_Logo
  • Categories
    • Questions
    • Predix | Updates
      • Pricing
      • Product
    • Deloitte - Private
    • How-To
    • Accenture-Private
  • Explore
    • Topics
    • Questions
    • Articles
    • Feedback or Feature Requests
  • Sign in
  • Home /
  • Questions /
avatar image
0
Question by Pankaj.Mahato@ge.com · Apr 26, 2019 at 03:18 AM · data-management

How to improve data transfer from Predix Postgres to Predix microservice?

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

Comment
Add comment
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

0 Replies

  • Sort: 

Follow this Question

Answers Answers and Comments

90 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Unable to save data into timeseries. "Socket is closed" error 2 Answers

How the time series data is routing to time series data store 1 Answer

Database Backup.... 1 Answer

How can i take a backup of predix postgres db and restore it to local database? 2 Answers

Can databus river be used to send specific data tags to an edge app in a Predix Machine dockerized environment? 2 Answers

GE Monogram
  • Legal
  • Cookies
  • Forum Terms
  • Contact Us
  • Copyright © 2017 General Electric Company. All rights reserved.


Enterprise
Social Q&A

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Create an article
  • Submit your feedback or feature request
  • Categories
  • Questions
  • Predix | Updates
    • Pricing
    • Product
  • Deloitte - Private
  • How-To
  • Accenture-Private
  • Explore
  • Topics
  • Questions
  • Articles
  • Feedback or Feature Requests