(Best Practice) Using VACUUM with PostgreSQL for Talend Administration Center users

Talend MDM Platform Installation Guide for Solaris

EnrichVersion
6.5
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Artifact Repository
Talend Installer
Talend Data Preparation
Talend Identity and Access Management
Talend Data Stewardship
Talend MDM Web UI
Talend ESB
Talend MDM Server
Talend SAP RFC Server
Talend Activity Monitoring Console
Talend Administration Center
Talend Runtime
Talend Log Server
Talend Repository Manager
Talend Studio
Talend DQ Portal
Talend CommandLine
Talend JobServer

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.