# PostgresPlus components

| [tPostgresPlusBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusbulkexec) | Improves performance during Insert operations to a DB2 database. |
| --- | --- |
| [tPostgresPlusClose](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusclose) | Closes the transaction committed in the connected PostgresPlus<br>database. |
| [tPostgresPlusCommit](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgrespluscommit) | Commits in one go a global transaction, using a unique connection, instead of doing<br>that on every row or every batch and thus improves performance. |
| [tPostgresPlusConnection](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusconnection) | Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs. |
| [tPostgresPlusInput](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusinput) | Executes a DB query with a strictly defined order which must correspond to the<br>schema definition. Then it passes on the field list to the next component via a Main row<br>link. |
| [tPostgresPlusOutput](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusoutput) | Executes the action defined on the table and/or on the data contained in the table,<br>based on the flow incoming from the preceding component in the job. |
| [tPostgresPlusOutputBulk](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusoutputbulk) | Prepares the file to be used as parameter in the INSERT query to<br>feed the PostgresPlus database. |
| [tPostgresPlusOutputBulkExec](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusoutputbulkexec) | Improves performance during Insert operations to a PostgresPlus<br>database. |
| [tPostgresPlusRollback](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusrollback) | Avoids to commit part of a transaction involuntarily. |
| [tPostgresPlusRow](https://help.qlik.com/talend/r/en-US/7.3/components/postgresplus/tpostgresplusrow) | Acts on the actual DB structure or on the data (although without handling data),<br>depending on the nature of the query and the database. The SQLBuilder tool helps you<br>write easily your SQL statements. |