Help Center/ GaussDB/ Best Practices/ Best Practices Overview
Updated on 2025-09-12 GMT+08:00

Best Practices Overview

This section describes best practices for working with GaussDB and provides operational guidelines that you can follow when using this service.
Table 1 GaussDB best practices

Document

Description

Suggestions on GaussDB Security Configuration

Provides guidance on GaussDB security configurations.

Best Practices for Scaling

Describes the use cases of different scaling operations.

Best Practices for Backup and Restoration

Describes typical accidental operations and their corresponding recovery methods.

Suggestions on GaussDB Metric Alarm Configuration

Describes how to configure GaussDB metric alarm rules.

Best Practices for Row Compression

Describes how to use manual and automatic scheduling to compress data.

Best Practices for SQL Queries

Describes how to adjust SQL statements to improve SQL execution efficiency.

Best Practices for Permission Configuration

Describes the responsibilities and capabilities of different permission types and roles, as well as how to configure permissions.

Best Practices for Data Skew Query (Distributed Instances)

Describes how to identify tables that cause data skew.

Best Practices for Stored Procedures

Describes key aspects of stored procedures, including permission management, naming conventions, access to database objects, statement functions, and transaction management.

Best Practices for Import and Export Using COPY

Describes how to use the COPY syntax to import and export data.

Best Practices for Import and Export Using Tools

Describes how to use gs_dump and gs_dumpall to import and export data.

Best Practices for JDBC

Describes how to use JDBC for efficient data operations, including inserting data in batches, executing streaming queries, handling user-defined data types, and performing batch queries.

Best Practices for ODBC

Describes how to use the ODBC driver for batch data insertion.

Best Practices for Go

Describes how to use the Go driver for batch data insertion.

Best Practices for Index Design

Compares the performance of querying large tables containing over a million rows both with indexes and without them, and evaluates the effectiveness of single-column indexes versus composite indexes for optimizing query efficiency.

Best Practices for Table Design

Describes distribution mode and key design, data type selection, partitioning policies, constraint configuration, index optimization, and tuning of storage parameters.