When connecting to a Vertica database through a vsql COPY command or through an ODBC connection, the SET SESSION AUTOCOMMIT option is set to Off by default.
To ensure optimal performance, Vertica recommends retaining the default SET SESSION AUTOCOMMIT setting. When SET SESSION AUTOCOMMIT is set to Off, transactions are not automatically committed after a specified number of records are processed.
For additional information on SET SESSION AUTOCOMMIT, see the SQL Statements section of the Vertica Enterprise SQL Reference Manual.