Parameter Categories

Configuration parameters affect categories of server behaviors, such as resource consumption, query tuning, and authentication. The following topics describe SynxDB configuration parameter categories.

Connection and Authentication Parameters

These parameters control how clients connect and authenticate to SynxDB.

Connection Parameters

Security and Authentication Parameters

System Resource Consumption Parameters

These parameters set the limits for system resources consumed by SynxDB.

Memory Consumption Parameters

These parameters control system memory usage.

OS Resource Parameters

Cost-Based Vacuum Delay Parameters

Caution Do not use cost-based vacuum delay because it runs asynchronously among the segment instances. The vacuum cost limit and delay is invoked at the segment level without taking into account the state of the entire SynxDB array

You can configure the execution cost of VACUUM and ANALYZE commands to reduce the I/O impact on concurrent database activity. When the accumulated cost of I/O operations reaches the limit, the process performing the operation sleeps for a while, Then resets the counter and continues execution

Transaction ID Management Parameters

Other Parameters

GPORCA Parameters

These parameters control the usage of GPORCA by SynxDB. For information about GPORCA, see About GPORCA in the SynxDB Administrator Guide.

Query Tuning Parameters

These parameters control aspects of SQL query processing such as query operators and operator settings and statistics sampling.

Postgres Planner Control Parameters

The following parameters control the types of plan operations the Postgres Planner can use. Enable or deactivate plan operations to force the Postgres Planner to choose a different plan. This is useful for testing and comparing query performance using different plan types.

Postgres Planner Costing Parameters

Caution Do not adjust these query costing parameters. They are tuned to reflect SynxDB hardware configurations and typical workloads. All of these parameters are related. Changing one without changing the others can have adverse affects on performance.

Database Statistics Sampling Parameters

These parameters adjust the amount of data sampled by an ANALYZE operation. Adjusting these parameters affects statistics collection system-wide. You can configure statistics collection on particular tables and columns by using the ALTER TABLE SET STATISTICS clause.

Sort Operator Configuration Parameters

Aggregate Operator Configuration Parameters

Join Operator Configuration Parameters

Other Postgres Planner Configuration Parameters

Query Plan Execution

Control the query plan execution.

Error Reporting and Logging Parameters

These configuration parameters control SynxDB logging.

Log Rotation

When to Log

What to Log

System Monitoring Parameters

These configuration parameters control SynxDB data collection and notifications related to database monitoring.

SynxDB Performance Database

The following parameters configure the data collection agents that populate the gpperfmon database.

Query Metrics Collection Parameters

These parameters enable and configure query metrics collection. When enabled, SynxDB saves metrics to shared memory during query execution.

Runtime Statistics Collection Parameters

These parameters control the server statistics collection feature. When statistics collection is enabled, you can access the statistics data using the pg_stat family of system catalog views.

Automatic Statistics Collection Parameters

When automatic statistics collection is enabled, you can run ANALYZE automatically in the same transaction as an INSERT, UPDATE, DELETE, COPY or CREATE TABLE...AS SELECT statement when a certain threshold of rows is affected (on_change), or when a newly generated table has no statistics (on_no_stats). To enable this feature, set the following server configuration parameters in your SynxDB master postgresql.conf file and restart SynxDB:

Caution Depending on the specific nature of your database operations, automatic statistics collection can have a negative performance impact. Carefully evaluate whether the default setting of on_no_stats is appropriate for your system.

Client Connection Default Parameters

These configuration parameters set defaults that are used for client connections.

Statement Behavior Parameters

Locale and Formatting Parameters

Other Client Default Parameters

Lock Management Parameters

These configuration parameters set limits for locks and deadlocks.

Resource Management Parameters (Resource Queues)

The following configuration parameters configure the SynxDB resource management feature (resource queues), query prioritization, memory utilization and concurrency control.

Resource Management Parameters (Resource Groups)

The following parameters configure the SynxDB resource group workload management feature.

External Table Parameters

The following parameters configure the external tables feature of SynxDB.

Database Table Parameters

The following parameter configures default option settings for SynxDB tables.

Append-Optimized Table Parameters

The following parameters configure the append-optimized tables feature of SynxDB.

Past Version Compatibility Parameters

The following parameters provide compatibility with older PostgreSQL and SynxDB versions. You do not need to change these parameters in SynxDB.

PostgreSQL

SynxDB

SynxDB Array Configuration Parameters

The parameters in this topic control the configuration of the SynxDB array and its components: segments, master, distributed transaction manager, master mirror, and interconnect.

Interconnect Configuration Parameters

Note SynxDB supports only the UDPIFC (default) and TCP interconnect types.

Dispatch Configuration Parameters

Fault Operation Parameters

Distributed Transaction Management Parameters

Read-Only Parameters

SynxDB Mirroring Parameters for Master and Segments

These parameters control the configuration of the replication between SynxDB primary master and standby master.

SynxDB PL/Java Parameters

The parameters in this topic control the configuration of the SynxDB PL/Java language.

XML Data Parameters

The parameters in this topic control the configuration of the SynxDB XML data type.