Versions

openGauss 3.0.0 is the second release version of openGauss, and its lifecycle is 3.5 years. This release contains two database server installation packages: enterprise edition and lite edition. The lite version is designed to support openGauss when software and hardware resources are limited. It retains most features of the enterprise edition. This document applies only to the lite edition.

The lite edition has the following features:

(1) The lite version occupies few resources:

The actual size of the lite version installation package is less than 30 MB, and the no-load memory is less than 250 MB.

(2) The lite version is easy to install.

Compared with the enterprise edition, the installation process is simpler and faster.

(3) The following features are disabled by default in the lite version:

Ustore (inplace-update engine), active session profile (ASP), incremental checkpoint, double write, column store, segment-page store, full/slow SQL feature, workload feature, and SQL response time calculation, and database monitoring snapshot.

(4) The following features are not supported in the lite version:

ORC file access, Kerberos security verification, JAVA UDF, Codegen, MOT, SMP query, AI, fully-encrypted database, CM, and OM.

(5) The following simplified binary tools are provided:

Commonly used tools such as gsql, gs_ctl, gs_guc, gs_dump, gs_restore, gs_probackup and gs_initdb are reserved, and liteom is provided for installation, deployment, and upgrade.

The lite version is compatible with most features and functions of earlier versions. The main functions are as follows:

• Inherited functions:

  • SQL standard syntax, UPSERT, data type, XML type, table, temporary table, global temporary table, foreign table, view, materialized view, index, foreign key, generalized inverted index (GIN), sequence, function, trigger, ROWNUM, MEDIAN aggregate function, JSONB data type, GB18030 character set and UPSERT subquery.
  • Stored procedure, commit/rollback in stored procedure, omission of parameter parentheses () from the stored procedure or function calling, stored procedure debugging, and autonomous transaction.
  • Security features such as authentication, permission management, network communication security, database audit, SM algorithm, and built-in role and permission management.
  • HA functions such as primary/standby two-node cluster, cascaded standby node, logical replication, ultimate RTO, standby node scale-out, and Paxos-based distributed consensus framework (DCF).
  • Range partitioning, global partitioned indexes, LIST partitioning, HASH partitioning, and automatically extended partition based on range partitions.
  • Full physical backup, logical backup, standby node backup, incremental backup and restoration, and point-in-time recovery (PITR).
  • NUMA-aware high-performance optimization, parallel query, and automatic eviction of unique SQL statements.
  • Storage features such as delayed standby node replay, logical replication on standby nodes, Xlog archiving on standby nodes, I/O write amplification optimization on standby nodes, and hash index.
  • Load balancing and read/write isolation on the JDBC client, CMake script compilation, container-based deployment, IPv6 protocol, and postgis plug-in.

• New functions:

  • Row-store execution to vectorized execution
  • Delay of entering the maximum availability mode
  • Parallel logical decoding
  • Global syscache
  • Foreign key lock enhancement
  • Row-store table compression
  • Open-source Data Studio
  • MySQL to openGauss migration tool Chameleon
  • Using ShardingSphere to build a distributed database
  • Deploying a distributed database using Kubernetes

• Modified defects:

  • I4VUXG: Fixed the data loss issue of unlogged tables.
  • I4SF5P: Fixed the core dump issue occurred by running create extension dblink after the database is compiled and installed in the release version, and the dblink module is compiled and installed.
  • I4S74D: Fixed the issue of failing to insert data (5/5) into a row-store compressed table using Jmeter when the data volume is greater than 1 GB. The compression type is set to 2.
  • I4YPJQ: Fixed the issue of failing to insert varchar constants into MOTs using JDBC.
  • I4PF6G: Fixed the issue of TPC-C execution failure during foreign key lock enhancement and gray upgrade from 2.0.0. to 2.2.0 (not committed).
  • I4WPD1: Fixed the issue of failing to execute simplified installation because the openGauss-2.1.0-CentOS-64bit.tar.bz2 file is missing in the decompressed installation package.
  • I4L268: Fixed the issue of incorrect system catalog pg_partition after the partitioned table is truncated for multiple times and then the vacuum freeze pg_partition command is executed.
  • I3HZJN: Fixed the issue of incorrect date format when the copy command is executed.
  • I4HUXD: Fixed the issue of failing to query the JSONB type.
  • I4QDN9: Fixed the issue of returning a value for select 1.79E +308*2,cume_dist() over(order by 1.0E128*1.2) out of range.
  • I4PAVO: Fixed the issue of failing to identify the start with connect by record subquery.
  • I4UY9A: Fixed the issue of failing to create the default partition during list partitioning.
  • I4W3UB: Fixed the issue of failing to obtain the view definition when the view is created using a user-defined type and the user-defined type is renamed.
  • I4WRMX: Fixed the issue of failing to clear data in the statement_history table. When the database restarts and the enable_stmt_track parameter is disabled, no record should be found in the statement_history table.
  • I4WOBH: Fixed the issue of failing to restart the database by setting GUC parameter pagewriter_sleep from 360000 to 2000.