Post load performance and tuning - Connect_ETL - Latest

Connect ETL Vertica Load Guide

Product type: Software
Portfolio: Integrate
Product family: Connect
Product: Connect > Connect (ETL, Sort, AppMod, Big Data)
Version: Latest
ft:locale: en-US
Product name: Connect ETL
ft:title: Connect ETL Vertica Load Guide
Copyright: 2025
First publish date: 2003
ft:lastEdition: 2025-05-21
ft:lastPublication: 2025-05-21T18:34:10.033000

To enhance the performance of the database load consider the following optimization techniques:

Verify that the SET SESSION AUTOCOMMIT option is disabled.
Distribute the load across Vertica initiator nodes.