Controlling the autocommit setting for PostgreSQL connections
Administrators can use this configuration option to control the autocommit setting for PostgreSQL database connections. Previously, autocommit was enabled by default, which could affect performance or cause memory errors during large data operations.
After you select as the connection type, click to access the Enable Autocommit switch.
You can choose whether autocommit is enabled or disabled for the connection.
When you select a value for the connection, the value is applied in these ways:
- It is saved in the connection settings.
- It is reflected in system logs during the data preview and data extraction.
- It is included in API requests and responses for the connection creation and testing.
If no value is selected for previous connections, autocommit remains enabled by default for the compatibility purposes.
The selected setting is saved in this internal configuration file: connection_config.xml.
These enhancements apply to all PostgreSQL connection types:
- Agent
- Agentless
- Cloud-to-Cloud (C2C)
The retrieval size is automatically determined based on the database type. Therefore, no manual setup is required.
Autocommit provides you with more flexibility and control over PostgreSQL connections.
It has these benefits:
- Improves performance during large data loads.
- Prevents out-of-memory issues that are caused by transaction handling.
- Ensures smoother and more reliable data operations.