Tantor DB Special Edition (Astra Linux)

Tantor DB Special Edition (Tantor DB SE) is an enterprise-level PostgreSQL-based DBMS. It is designed for most loaded enterprise systems or enterprise storages of up to 100 TB.

Tantor DB is suitable for all public and commercial domains that use DBMS’s.

Changes to DBMS core

• 64-bit transaction counter.
• Higher DBMS performance with a large number of active users.
• More partitions in the shared buffer.
• The pglz compression algorithm is optimized by around 1.4 times.
• Fewer data page locks in the shared buffer.
• WAL file compression feature using the lz4 and zstd algorithms, as well as through libpq.
• Support for autonomous transactions.
• Removing the cyclic nature of data through two-sided logical replication.
• Optimized and faster recovery for the standby fadvise cascade replication.
• Terminating sessions upon a specified timeout.
• Terminating transactions upon a specified timeout.
• Checksums for data pages are enabled by default.
• Adding new reserved connections. You can specify the number of such connections in the reserved_connections property of the configuration file. This enables reserving connection slots for the users that are not superusers. The slots reserved through this property are only available to the users that may have the new pg_use_reserved_connections predefined role.
• Support for ARM64.
• Higher speed when processing streaming data; this also applies to working with text and JSON for ARM-based CPUs.
• Linear search optimization for ARM64-based CPUs.

Additional modules

• ORC (Optimized Row Columnar)
• credcheck
• hypopg
• orafce
• pgaudit
• pgauditlogtofile
• pg_cron
• pg_hint_plan
• pg_partman
• pg_qualstats
• pgsql-http
• pg_store_plans
• pg_variables
• pg_wait_sampling
• page_repair
• pg_background
• pgq

1. Get an SSH key pair to connect to a virtual machine (VM).

2. Create a VM from a public image:

   • Under Image/boot disk selection, go to the Cloud Marketplace tab and select Tantor DB Special Edition (Astra Linux).
   • Under Access:
     • Enter the username in the Login field.
     • Paste the contents of the public SSH key file in the SSH key field.

   Save the public IP address and VM ID.

3. Connect to the VM over SSH. Use the username you provided when creating the VM, as well as the generated private SSH key.

4. Check the service status:

   sudo systemctl status tantor-se-server-15
   

5. Run a test query to the database:

   sudo su - postgres -c 'psql -c "select tantor_version(), tantor_edition(), tantor_build();"'
   

6. Connect to the database:

   sudo -iu postgres psql
   

For more information on Tantor DB, see Installing and configuring Tantor DB Special Edition 15 image (in Russian).

• Database administration

Astralinux
Astralinux provides technical support to Tantor DB Special Edition users in Yandex Cloud. For more information on the technical support terms, see the relevant Technical Support Terms and Conditions (in Russian).

Yandex Cloud
Yandex Cloud does not provide technical support for this product. If you have any issues, please refer to the respective developer’s information resources.