Release date: 2021-10-24
This release contains a variety of changes from LightDB 13.3-21.1.
This version contains a database monitor and management platform, the LightDB Enterprise Manager (LightDB-EM) embedded version, provides monitoring and management solution for LightDB.
New Installation Wizard, with GUI and CLI mode. Allows you to simply and easily install standalone or high-available deployment LightDB, including the LightDB-EM.
Enhance PWR and ASH, especially wait-event. Helping you to find out most resource-consuming activities and top SQL in your LightDB databases.
Enhance Oracle compatibilty, as following: Function. rowid, sysdate, nvl function supports numeric, real, integer, text, varchar, bpchar, bit conversion. guid function. DataType. clob, blob, varchar2, number, rowid.
Enhance MySQL compatibilty, as following: Function. uuid function. DataType. datetime. Syntax and features. Supporting AUTO_INCREMENT, ON UPDATE CURRENT_TIMESTAMP.
Add a new GUC parameter lightdb_keep_temp_file, for debug purpose. Allowing temporary files, such as sort and hash temporary files, be retained.
Add Ordered optimizer hint, which is equivalent to Leading optimizer hint.
To Improve database design and best practice, LightDB introduce design checking through DDL. Five kinds of checkings are supporting now: keyword_not_allowed,bad_datatype,must_have_pk,must_have_gmt,no_more_100cols. these rules can enable all or enable as needed, like MySQL's sql-mode. GUC parameters lightdb_best_practice_mode and lightdb_best_practice_level used for controling the rule. Existing object all not affected.
To improve legacy system pull-mode incremental-sync speed, LightDB support hidden auto-increment primary key column and hidden update timestamp column. Add WITH PRIMARY KEY to create an implicit column ltapk, which will be incremented automatically when a new row is inserted. Add WITH UPDATE CURRENT_TIMESTAMP to create an implicit column ltaut, which will be updated automatically when row a is inserted or modified.
The following built-in extensions are auto enabled by default in every database, user don't need to perform CREATE EXTENSION manually.
pg_log_long_xact, pl/pgsql function to log long running transactions
pg_bulkload, pg_bulkload is a high speed data loading utility for LightDB, an replacement for COPY command
system_stats, system statistic functions for LightDB
timescaledb, enables scalable inserts and complex queries for time-series data
zhparser, a parser for full-text search of Chinese. The default configuration name is zhcfg
rum, RUM index access method, a faster full text search implementation.
tsvector2, a extended format of tsvector, a better space usage datatype for full text search.
The following extensions are also built-in but not enabled by default, perform CREATE EXTENSION before using them.
mysql_fdw, a Foreign Data Wrapper (FDW) for MySQL
oracle_fdw, a Foreign Data Wrapper for Oracle