Skip to content

Instantly share code, notes, and snippets.

@W3BGUY

W3BGUY/Jitterbit_PostgreSQL_Update

Last active August 19, 2022 14:49
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save W3BGUY/3889202bce3c0e25341e5fb80b5bf9fb to your computer and use it in GitHub Desktop.
Save W3BGUY/3889202bce3c0e25341e5fb80b5bf9fb to your computer and use it in GitHub Desktop.
Download ZIP
Updates to improve PostgreSQL performance.
Raw
Jitterbit_PostgreSQL_Update
Add to Jitterbit.conf file
[LogSync]
# Max number of records at once to sync - This is the initial batch size only! After retries it goes
#back to MinRecordsToSync!
MaxRecordsToSync=500
#Max sleep between retries
MaxRetryDelaySec=60
#It's actually the maximum after retries have kicked in!
MinRecordsToSync=500
In resources/jitterbit-agent-config.properties
Add: sync.agent.thread.executor.max.pool.size=20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment