GC overhead limit exceeded error

[Anonymous]

Hello, 

I am new to Talend and was trying to transfer data from my data source server (postgresql) to warehouse server (postgresql). In doing so, I am getting an error, screenshot attached (with designer and error), "GC overhead limit exceeded". Can anyone help me out?

Thanks!

[vapukov · Accepted solution]

Hi,

welcome to community

you can try one of the next methods:

1. increase memory Xmx in Advanced Settings (Run tab)

2. you could test auto-commit (in tPostgreSQLConnection advanced settings) instead of a single transaction - in case if data too big

3. in addition to 2 you could check "use cursor" in advanced settings

[Anonymous]

Hi,

Not enough memory, try to increase it : 

RUN->Advanced setting-> Use specific JVM arguments

Thanks