PostgreSql Reader

PostgreSQL source is used to extract data PostgreSQL/Greenplum databases.

About PostgreSQL

PostgreSQL is an open-source, advanced relational database management system (RDBMS). It supports SQL and powerful features like complex queries, foreign keys, triggers, and full ACID compliance. It’s known for reliability, extensibility, and support for both structured and unstructured data.

Properties

Tip: To change Reader properties double click on it.

Count Number of Records

When user run a transformation, software displays a progress bar and completion percentage.

To calculate this percentage, the software must first determine the total number of records in the source table.This record-counting operation can take a significant amount of time, especially for large tables, and may negatively impact overall performance.

Disabling Count Number of Records prevents the software from counting the records before processing begins, allowing the transformation to start immediately and potentially improving performance.