PostgreSQL Configuration

• table.orientation

Default data storage mode. ROW: row storage. COLUMN: column storage.

• COLUMN
• ROW

• COLUMN

• table.orientation=COLUMN

• table.type

Default table type, which can be partitioned table, replication table, or round-robin table. The value can be REPLICATION, HASH, or ROUND-ROBIN.

• REPLICATION
• HASH
• ROUND-ROBIN
• Null

• Null

• table.type=

• table.compress.level

Compression level of table data. It determines the compression ratio and duration.

• The valid values of row-store tables are Yes and No.
• The valid values for column-store tables are YES, NO, LOW, MIDDLE, and HIGH.

The default value is Null, indicating that no compression level is set.

Row-store tables:

• YES
• NO

Column-store tables:

• YES
• NO
• LOW
• MIDDLE
• HIGH

• Null

• table.compress.level=

• table.colversion.version

Version of the column-store storage format. You can switch between different storage format versions. Value range: Null (default value), 1.0, or 2.0

• 1.0
• 2.0
• Null

• Null

• table.colversion.version=

• table.enable.delta

Whether to enable delta tables in column-store tables. This parameter is valid only for column-store tables. Value range: Null (default value), true, or false

• true
• false
• Null

• Null

• table.enable.delta=

• table.output.placeholder.format

Whether to use the String.format template (for example, $%s) to define the variable output format. %s is replaced with the actual variable name.

• StringFormat

• Null

table.output.placeholder.format=

• table.output.foreign.server

Default server of the GDS foreign table.

• serverName

• gsmpp_server

• table.output.foreign.server=gsmpp_server

• table.output.foreign.obs.server

Default server of an OBS foreign table.

• serverName

• obs_server

• table.output.foreign.obs.server=obs_server

• table.output.char.coefficient

Char length coefficient (number), which is used when the storage logic of the char field is inconsistent. The char length is multiplied by this coefficient.

• Integer

• 1

• table.output.char.coefficient=1

• table.output.varchar.coefficient

Varchar length coefficient (number), which is used when the storage logic of the varchar field is inconsistent. The varchar length is multiplied by this coefficient.

• Integer

• 1

• table.output.varchar.coefficient=1

• table.output.bpchar.coefficient

Bpchar length coefficient (number), which is used when the storage logic of the bpchar field is inconsistent. The bpchar length is multiplied by this coefficient.

• Integer

• 1

• table.output.bpchar.coefficient=1

• table.output.generate.sequence

Whether to automatically generate the CREATE SEQUENCE statement when the CREATE TABLE statement contains nextval. The value can be Y or N.

• Y
• N

• Y

• table.output.generate.sequence=Y

• table.output.column.keyword

When a subsequent keyword is used as a column name, backquotes (`) are automatically added to the column name.

Example: SELECT `group`, `performance`, `hash`, `hot`, `matched`, `reject`, `interval`, `modify`, `timestamp`

• keyWords

• Identified keywords by default

• table.output.column.keyword=group,performance,hash,hot,matched,reject,interval,modify,timestamp

• table.output.column.type.convert

User-defined type mapping, which is case insensitive. Example: char|varchar,character|varchar,bpchar|varchar

• oldDataType|newDataType

• Null

• table.output.column.type.convert=

• table.output.partition.valueslessthan

Whether to convert the partition mode start end to values less than. The value can be Y or N.

• Y
• N

• Y

• table.output.partition.valueslessthan=Y

• table.output.role.name.convert

User-defined role name mapping, which is case insensitive. Example: gpadmin|dbadmin,admin|dbadmin

• oldName|newName
• Null

• Null

• table.output.role.name.convert=gpadmin|dbadmin