Updates in 2024

Sep 2024, Tacnode engine release version 1.0

This engine update includes the following updates:

• Supports the MERGE INTO statement, which integrates the INSERT, UPDATE, and DELETE operations into one command. It performs the relevant operation based on the matching conditions between the source and target tables. The MERGE INTO command offers an efficient, concise, and consistent method for synchronizing data across two tables. For more details on usage, see MERGE INTO.

• Facilitates DELETE USING statements. The DELETE USING syntax extends the basic DELETE statement, enabling the reference of additional tables during the deletion process. This enhancement streamlines intricate deletion tasks that involve multiple tables in one SQL statement. For more information, see DELETE.

• Enables the reading of table data at a specific time and allows for reading data at a predetermined moment. See Time Travel for more information.

• Enables the creation of several read-only replicas for processing at the database level. For more information, see Read-only Replication Instance.

• Provides comprehensive full-text search features. For further information, see Full-text Search.

• It automatically generates adaptive indexes for text and date fields like split_bitmap, eliminating the need for manual setup. See Bitmap for more information.

• Track the status of data copying with pg_stat_progress_copy. To monitor index creation progress, use pg_stat_progress_create_index. For more information, refer to Progress Reporting.

• Compatible with the binary PostgreSQL wire protocol. In COPY operations, data is sent in binary format, enhancing system throughput and processing efficiency. This is ideal for psycopg3 clients.

• Enhanced memory safeguards improve the stability of system operations.

• Enhances the system's scheduling strategy so that all queries are equitable and CPU resources are completely utilized.