When using Talend Administration Center to retrieve, schedule and/or execute Jobs, many update/delete database operations are performed, which may result in performance slowdown if you are using PostgreSQL.
Indeed, it is recommended to execute the VACUUM
command with PostgreSQL, as
items that are deleted or obsoleted by an update are not physically removed from their
table.
For more information on the VACUUM
command, see the PostgreSQL
documentation.
For more information on how to set up automatic vacuuming (which is a process launched at
regular intervals by the PostgreSQL server to execute VACUUM
only on the tables
that have been updated), see the PostgreSQL documentation.