Stream Compute Service
- Releases Notes and Announcements
- Getting Started
- Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Events and Diagnosis
- Managing Metadata
- Tuning Jobs
- Managing Clusters
- Managing Permissions
- SQL Developer Guide
- DDL Statements
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
- ETL Developer Guide
PostgreSQL Sinks
Last updated: 2023-11-08 16:20:19
Overview
A PostgreSQL data sink can write data to the PostgreSQL database.
Notes
Primary key
All data generated by an ETL data source table is UPSERT data, so it's important that you correctly define the primary key for the PostgreSQL database table.
The primary key defined for the data sink table must be the same as that defined for the physical table. Otherwise, an error may occur after the task is started.
WITH parameters
PostgreSQL data sinks are developed based on JDBC and support the following sink-related configurations:
Parameter | Required | Default Value | Description |
sink.buffer-flush.max-rows | No | 100 | The maximum size of buffered data records before flush. If this is set to 0, no data will be buffered. |
sink.buffer-flush.interval | No | 1s | The maximum interval (ms) between flushes. If sink.buffer-flush.max-rows is 0, and this parameter is not, buffered actions will be processed asynchronously. |
sink.max-retries | No | 3 | The maximum number of retries allowed when a write operation fails. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No