2020-12-30

This issue is the twenty-first official release.

2020-11-10

This issue is the twentieth official release.

The following sections are deleted:

• SQL Reference (An independent document Data Warehouse Service SQL Syntax Reference is provided.)
• Full Text Search

2020-08-24

This issue is the nineteenth official release.

The following sections are added:

• Using gs_dump and gs_dumpall to Export Data
• gs_dump
• gs_dumpall

The sections related to best practices are deleted (An independent document Data Warehouse Service Best Practices is provided).

2020-07-31

This issue is the eighteenth official release.

2020-07-10

This issue is the seventeenth official release.

The following section is added:

• Syntax Compatibility Differences Between Teradata and Oracle

The following sections are modified:

• Tutorial: Development Using JDBC or ODBC
• Optimizing Statistics

2020-04-20

This issue is the sixteenth official release.

The following sections are added:

• Oracle compatibility - synonym
  • PG_SYNONYM
  • ALL_SYNONYMS
  • DBA_SYNONYMS
  • USER_SYNONYMS
• KPI monitoring - SQL adaptation
  • GLOBAL_WORKLOAD_SQL_COUNT
  • GLOBAL_WORKLOAD_SQL_ELAPSE_TIME
  • GS_INSTR_UNIQUE_SQL
  • PGXC_WORKLOAD_SQL_COUNT
  • PGXC_WORKLOAD_SQL_ELAPSE_TIME
  • PGXC_INSTR_UNIQUE_SQL
  • GS_WORKLOAD_SQL_COUNT
  • GS_WORKLOAD_SQL_ELAPSE_TIME
  • PV_INSTANCE_TIME
  • PV_SESSION_TIME

• Transaction enhancement
  • PGXC_VARIABLE_INFO
  • PGXC_GTM_SNAPSHOT_STATUS
• plan table
  • PLAN_TABLE
  • PLAN_TABLE_DATA
• Row- and column-level data access control (Row-Level Access Control)

• Quick detection of storage skew
  • PG_STAT_ALL_TABLES
  • Query and Index Statistics Collector

2019-04-30

This issue is the fifteenth official release.

The following sections are modified:

• Express Functions

2019-04-10

This issue is the fourteenth official release.

The following sections are added:

• ANALYZE enhancement: Doing VACUUM to a Table
• Optimization of data skew calculation: Skew Hints
• Read a page from the standby node if it is damaged on the primary node.
  • PGXC_STAT_BAD_BLOCK
  • PG_STAT_BAD_BLOCK
• Enhancement of logical cluster features: GS_TOTAL_NODEGROUP_MEMORY_DETAIL
• Enhancement of distributed execution frameworks: PGXC_STAT_ACTIVITY
• Transaction Isolation
• Record type supported: record
• GOTO syntax: GOTO Statements
• System catalog and view adaptation:
  • ALL_CONSTRAINTS
  • ALL_CONS_COLUMNS
  • ALL_IND_COLUMNS
  • ALL_INDEXES
  • ALL_TAB_COMMENTS
  • DBA_COL_COMMENTS
  • DBA_CONSTRAINTS
  • DBA_CONS_COLUMNS
  • DBA_IND_COLUMNS
  • DBA_IND_EXPRESSIONS
  • DBA_IND_PARTITIONS
  • DBA_TAB_COMMENTS
  • USER_COL_COMMENTS
  • USER_CONSTRAINTS
  • USER_CONS_COLUMNS
  • USER_IND_COLUMNS
  • USER_IND_EXPRESSIONS
  • USER_TAB_COMMENTS

The following sections are modified:

• GDS enhancement:
  • Installing, Configuring, and Starting GDS
  • Creating a GDS Foreign Table
• Enhancement of resource management and concurrency control: I/O Priority Scheduling
• Enhancement of distributed execution frameworks:
  • SQL Execution Plan
  • GS_WLM_SESSION_HISTORY
  • GS_WLM_SESSION_INFO
  • PG_COMM_RECV_STREAM
  • PG_COMM_SEND_STREAM
  • PGXC_COMM_RECV_STREAM
  • PGXC_COMM_SEND_STREAM
  • PGXC_GROUP
• Optimization of the column-oriented hash agg algorithm: SQL Execution Plan Details
• Optimization of data skew calculation: Optimizing Data Skew
• Enhancement of key operators and function pushdown: Optimizing Statement Pushdown
• Enhancement of logical cluster features:
  • PG_AUTHID
  • PG_RESOURCE_POOL
  • PGXC_GET_TABLE_SKEWNESS
• 64-bit transaction IDs:
  • PG_CLASS
  • PG_DATABASE
  • PG_PARTITION
  • PG_PROC
• System catalog and view adaptation:
  • ALL_DEPENDENCIES
  • ALL_TAB_COLUMNS
  • ALL_VIEWS
  • DBA_IND_PARTITIONS
  • DBA_INDEXES
  • DBA_TAB_COLUMNS
  • DBA_TAB_PARTITIONS
  • DBA_TABLES
  • USER_INDEXES
  • USER_TAB_COLUMNS
  • USER_TAB_PARTITIONS
  • USER_TABLES
• Adding of the GUC parameter support_batch_bind: Developer Operations
• Modification of the GUC parameter behavior_compat_options: Miscellaneous Parameters
• Advanced package supported: DBMS_LOB

2019-02-28

This issue is the thirteenth official release.

The following section is modified:

• Workload Management

The following sections are added:

• Real-Time TopSQL
• Historical TopSQL
• Example for Querying for Top SQLsExample for Querying for Top SQLs

2019-02-01

This issue is the twelfth official release.

The following sections are modified:

• Import Modes
• Querying User Resources

The following sections are added:

• HA Transaction Processing
• High Query Performance
• Importing Stream Data from DIS to GaussDB(DWS)
• Using CDM to Migrate Data to GaussDB(DWS)
• Using the DSC Tool to Migrate SQL Scripts
• PG_TOTAL_USER_RESOURCE_INFO

2018-11-24

This issue is the eleventh official release.

The following sections are modified:

PL/Java User-defined Functions

Querying User Resources

The following sections are added:

PG_TOTAL_USER_RESOURCE_INFO

2018-10-30

This issue is the tenth official release.

The following sections are added:

• PG_STATISTIC_EXT

The following section is modified:

• PL/Java User-defined Functions

2018-09-30

This issue is the ninth official release.

The following sections are modified:

• GUC parameter track_sql_count: Query and Index Statistics Collector
• Description about multi-column statistics: Updating Statistics

2018-08-30

This is the eighth official release.

The following sections are added:

• OBS Query Overview
• Querying Data on MRS

The following sections are modified:

• About Parallel Data Import from OBS

2018-07-10

This issue is the seventh official release.

The following sections are added:

• Using a gsql Meta-Command to Import Data
• Data Import Using COPY FROM STDIN

The following sections are modified:

• Technical Specifications

2018-05-15

This issue is the sixth official release,

The following sections are added:

• Development and Design Proposal
• Importing Data In Parallel Using GDS
• Exporting Data In Parallel Using GDS
• Viewing Parameter Values
• Resource Load Management Overview
• Information Schema

2018-04-09

This is the fifth official release.

The following sections are added:

• Target Readers

The following sections are modified:

• Technical Specifications
• 8.4-Creating a User and Granting Permissions
• Concurrently Importing Data from OBS
• Importing Data From MRS to a Data Warehouse Cluster
• Parallel OBS Data Export
• OBS Query Overview

2018-03-02

This issue is the fourth official release.

The following sections are added:

• Running the INSERT Statement to Insert Data
• Low Query Efficiency

The following sections are modified:

• About Parallel Data Import from OBS

The following sections are deleted:

• SQL error code reference: The document has been released as a separate document.

2018-02-02

This issue is the third official release.

The following sections are deleted:

• Product Positioning
• Product Features
• JDBC Application Developer Guide
• ODBC Application Developer Guide

2017-12-15

This issue is the second official release.

2017-11-24

This issue is the first official release.