Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Regarding Perforamce comparison between TOS with Native Postgres DB Vs Dedicated Postgres Linux DB

Hi Team,

 

Please suggest which approach will be faster in data load when done from Talend to Postgres DB.

One with  windows OS with TOS and Postgres DB in same machine or else TOS and Postgres server(Linux) in different machine under same network.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

There are many factors in play here. My suspicion would be that adding network latency would slow things down slightly, but that might be absorbed by more RAM and processing power on your server. There are no stats I can give you I'm afraid. I would try a significant load on both and see which is best.