Releases Notes and Announcements

Release Notes

Product Introduction

Overview

Strengths

Use Cases

Purchase Guide

Billing Overview

Billing Mode

Refund

Configuration Adjustments

Getting Started

Preparations

Creating a Private Cluster

Creating a SQL Job

Creating a JAR Job

Creating an ETL Job

Creating a Python Job

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

PostgreSQL Sinks

PDF

포커스 모드

폰트 크기

마지막 업데이트 시간: 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.
﻿

도움말 및 지원

문제 해결에 도움이 되었나요?

더 자세한 내용은 문의하기 또는 티겟 제출 을 통해 문의할 수 있습니다.

피드백

tencent cloud

Stream Compute Service

PostgreSQL Sinks

Overview

Notes

Primary key

WITH parameters

도움말 및 지원

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.