E.4. Release Notes for Tantor SE-1C 16.6.0#
E.4. Release Notes for Tantor SE-1C 16.6.0 #
Release date: 2024-12-12
E.4.1. Review #
Tantor SE-1C is a Russian-made DBMS based on the updated and improved version of the PostgreSQL DBMS. Tantor SE-1C 16.6.0 is based on PostgreSQL 16.
Below are the additional modules and utilities added to Tantor SE-1C, as well as a list of changes to the server core.
E.4.2. DBMS Core Functionality #
The following changes have been made to improve the DBMS:
Improved the algorithm for evaluating selectivity based on histograms for queries using joins across multiple columns of tables.
The algorithm for selecting a suitable index has been improved by taking into account the selectivity of each index considered by the scheduler. This makes it more likely to use an index that covers all conditions, which leads to faster query execution and savings in computing resources. As an example, this allows you to speed up the update of the totals of the accumulation registers.
Fixed an error in the
multicolumn indexmechanism, which leads to the selection of an incorrect index to determine selectivity under specified conditions.
E.4.3. Additional Supplied Programs #
Added extensions:
Updated extensions:
credcheck — to version 2.8
hypopg — to version 1.4.1
pg_cron — to version 1.6.4
pg_hint_plan — to version 1.6.1
pg_repack — to version 1.5.1
pg_store_plans — to version 1.8
pg_wait_sampling — to version 1.1.6
pgaudit — to version 17.0
pgauditlogtofile — to version 1.6.2
E.4.4. Migration to version 16.6.0 #
When upgrading within the current major version and edition, install Tantor SE-1C 16.6.0 and restart the database server with command:
systemctl restart tantor-se-1c-server-16
To migrate from PostgreSQL or Tantor DB, first install the latest minor version and then perform a data dump/restore using pg_dumpall, or use the pg_upgrade utility.
Additionally, to migrate from a PostgreSQL database with the Citus Columnar extension to a PostgreSQL database with the Hydra Columnar extension, you can use the columnar_migrator script, which ensures data integrity and compatibility.
Tantor DB version 16 uses new naming conventions for SLRU cache size parameters.
To migrate from version 15 to version 16 with respect to SLRU cache size parameters,
use the script upgrade-SLRU-from-TT_15-to-TT_16-version.sh.
The script is installed in /opt/tantor/db/16/tools/slru_upgrader/.
For script usage, please define the PGDATA variable, which should
specify the path to the cluster data directory of the migration target version (16).
Help information is also available with the command /opt/tantor/db/16/tools/slru_upgrader/upgrade-SLRU-from-TT_15-to-TT_16-version.sh --help.
The following table summarizes the changes in parameter names from Tantor DB 15 to
Tantor DB 16:
Table E.4. Parameter Name Changes
| Tantor DB 15 | Tantor DB 16 | Status |
|---|---|---|
| commit_ts_buffers | commit_timestamp_buffers | changed |
| serial_buffers | serializable_buffers | changed |
| subtrans_buffers | subtransaction_buffers | changed |
| xact_buffers | transaction_buffers | changed |
| multixact_members_buffers | multixact_members_buffers | unchanged |
| multixact_offsets_buffers | multixact_offsets_buffers | unchanged |
| notify_buffers | notify_buffers | unchanged |