Release date: 2021-08-17
This release contains a variety of changes from PostgreSQL 13.3.
The default values of some GUC parameters have been modified for better performance for modern hardware.
The native partition can be declared in clause statement of CREATE TABLE, which supports list, range and hash syntax.
Add lightdb_explain_no_runtime_pruned_partition parameter to control whether partitions pruned at runtime are shown in EXPLAIN ANALYZE output.
Built-in pg_hint_plan , which can control the execution plan with hinting phrases in comment of special form.
Built-in pg_wait_sampling, which provides sampling based statistics of wait events.
Built-in pg_profile, which can help you to find out most resource-consuming activities in your LightDB databases.
Built-in pg_cron, a simple cron-based job scheduler that runs inside the database. It uses the same syntax as regular cron, but it allows you to schedule LightDB commands directly from the database.
Built-in pg_cheat_funcs, which provides a set of cheat(but useful) functions on LightDB.
Built-in pgfincore, which provides a set of functions to handle low-level management of relations using mincore to explore cache memory.
Built-in orafce, an Oracle's compatibility functions and packages.
Built-in pgaudit, which provides detailed session and/or object audit logging via the standard LightDB logging facility.
Built-in pg_probackup, which manages backup and recovery of LightDB database clusters.
The following built-in extensions are auto enabled by default in every database(Except dblink, pg_profile and pg_cron, which is only available in postgres database), you don't need to perform CREATE EXTENSION manually.
pg_stat_statements
auto_explain
tablefunc
dblink
uuid-ossp
pg_hint_plan
pg_wait_sampling
pg_profile
pg_cron
pgfincore
orafce
pgaudit
Specially, a pg_cron job named "take_sample_every_10min" will be created automatically by default in postgres database. This job will call take_sample() every 10 minutes (take_sample() is provided by pg_profile extension).