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

[Anonymous]

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.

[Anonymous]

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.