E.10. Release Notes for Tantor SE-1C 16.6.0#

E.10. Release Notes for Tantor SE-1C 16.6.0

E.10. Release Notes for Tantor SE-1C 16.6.0 #

Release date: 2024-12-12

E.10.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.10.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 index mechanism, which leads to the selection of an incorrect index to determine selectivity under specified conditions.

E.10.3. Additional Supplied Programs #

Added extensions:

  • pg_trace — provides an opportunity for in-depth analysis and profiling of SQL queries, which is especially relevant for users of the 1C platform.

  • pg_uuidv7 — provides support for working with the UUIDv7 data type.

Updated extensions:

E.10.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.