Releases Notes and Announcements
- Release Notes
Product Introduction
Purchase Guide
Getting Started
Operation Guide
- Managing Jobs
- Developing Jobs
- Monitoring Jobs
- Job Logs
- Events and Diagnosis
- Managing Metadata
- Managing Checkpoints
- Tuning Jobs
- Managing Dependencies
- Managing Clusters
- Managing Permissions
SQL Developer Guide
- Overview
- Glossary and Data Types
- DDL Statements
- DML Statements
- Merging MySQL CDC Sources
- Connectors
- SET Statement
- Operators and Built-in Functions
- Identifiers and Reserved Words
Python Developer Guide
ETL Developer Guide
- Overview
- Glossary
- Connectors
FAQ
Contact Us

PostgreSQL Sinks

Mode fokus

Ukuran font

Terakhir diperbarui: 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.
﻿

Bantuan dan Dukungan

Apakah halaman ini membantu?

Anda juga dapat Menghubungi Penjualan atau Mengirimkan Tiket untuk meminta bantuan.

masukan

tencent cloud

Stream Compute Service

PostgreSQL Sinks

Overview

Notes

Primary key

WITH parameters

Bantuan dan Dukungan

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.