PostgreSQL Connector > PostgreSQL pushdown optimization > Pushdown optimization using the ODBC connection
  

Pushdown optimization using the ODBC connection

When you use an ODBC connection, you can configure pushdown optimization to push transformation logic to PostgreSQL source or target databases. Use pushdown optimization when you use database resources to improve the performance of the task.
When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
PostgreSQL Connector supports Full and Source pushdown optimization for the ODBC connection type that uses PostgreSQL ODBC drivers.