What follows are the release notes for the YugabyteDB 2025.2 release series. Content will be added as new notable features and changes are available in the patch releases of the YugabyteDB 2025.2 release series. For an RSS feed of all release series, point your feed reader to the [RSS feed for releases](../index.xml). ## v2025.2.2.1 - March 23, 2026 {#v2025.2.2.1} **Build:** `2025.2.2.1-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.2.2.1/yugabytedb-2025.2.2.1-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.2.2.1/yugabytedb-anywhere-2025.2.2.1-b1-third-party-licenses.html) ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2025.2.2.1-b1 ``` This is a YugabyteDB Anywhere-only release, with no changes to YugabyteDB. ## v2025.2.2.0 - March 12, 2026 {#v2025.2.2.0} ### Downloads {{< warning title="Use v2025.2.2.1.">}} v2025.2.2.0 includes an issue affecting LDAP in YugabyteDB Anywhere. In some circumstances, redacted values in `ysql_hba_conf_csv` can be overwritten during YBA-based universe operations, potentially leading to misconfigured database LDAP settings or authentication failures. Use [v2025.2.2.1](#v2025.2.2.1). {{< /warning >}} ### New features |

Feature

| Description | | :-------- | :---------- | | {{}}[Backup during DDLs](/stable/manage/backup-restore/) | Previously, metadata operations performed before backing up data to remote storage could fail if they ran concurrently with DDL operations. These metadata operations have been updated to succeed regardless of concurrent DDL activity, making the backup process more robust.

**To use**: Feature enabled by default. | |{{}}[Bucket-based index distribution support](/stable/develop/data-modeling/bucket-based-index-ysql/)| Addresses write-path hotspots for ascending/descending indexes while maintaining optimal performance for order-based queries.

**To use**: Set configuration parameters, `yb_enable_derived_equalities` and `yb_enable_derived_saops` to true, and a value for `yb_max_saop_merge_streams`. See [Parameters](/stable/develop/data-modeling/bucket-based-index-ysql/#parameters).| | {{}} [AWS ClockBound support](/stable/deploy/manual-deployment/system-config/#configure-clockbound)| [ClockBound](https://github.com/aws/clock-bound) is an open source daemon that allows you to compare timestamps to determine order for events and transactions, independent of an instance's geographic location; it improves clock accuracy by several orders of magnitude.

**To use**: Feature enabled by default. | ### Change log

View the detailed changelog

### Improvements #### YSQL * Allows `ALTER TABLE ALTER COLUMN SET STORAGE` without errors and logs a warning for YB tables. {{}} * Reduces unnecessary index rebuilds during ALTER TYPE operations that don't require a table rewrite. {{}} * Stops retrying DDL read restarts in the main PostgreSQL loop. {{}} * Enables `ysql_yb_enable_ddl_savepoint_support` as a preview feature, ensuring stability for user trials in pre-production environments. {{}} * Reduces unnecessary rechecks for hash code keys in scans. {{}} * Adds transaction IDs to CREATE DATABASE logs for easier debugging. {{}} * Enhances performance by reducing unnecessary PostgreSQL rechecks. {{}} * Allows normal users to set `yb_max_saop_merge_streams` for bucket-based indexes. {{}} * Reduces clutter in pg_stat_statements by aggregating `BACKFILL INDEX` entries under a single query identifier. {{}} * Enhances error hints for scenarios where databases are dropped and recreated. {{}} * `ysql_dump` respects the `PGHOST` environment variable, prioritizing the `-h` flag. {{}} #### DocDB * Enables detailed data and checksum dumps for tablets via new commands, aiding in consistency checks and troubleshooting. {{}} * Enables `log-dump` to read encrypted WAL files using the `master_addresses` flag. {{}} * Reduces log frequency to once per second for tablets stuck in bootstrapping. {{}} * Suppresses error logs for missing files on deletion to streamline operations. {{}} * Adds background checks for TServer connectivity and shares results via RPC. {{}} * Logs tserver start time and PID for easier troubleshooting. {{}} * Tracks and alerts on more RPC rejections due to memory pressure. {{}} * Enables system catalog flush and compaction across all yb-master peers. {{}} * Marks `follower_unavailable_considered_failed_sec` as a runtime flag. {{}} * Skips replication of PUBLICATION and SUBSCRIPTION DDLs in xCluster mode. {{}} * Fixes lock order inversion during table creation failures. {{}} * Sets yb_hnsw as the default backend for vector indexes. {{}} * Adds detailed metrics for vector index operations in DocDB. {{}} * Displays TServer connectivity states in the Web UI. {{}} * Stores both original and pause errors in xCluster DDL for easier debugging. {{}} * Adds "DETAIL" prefix to master and tserver log lines for clarity. {{}} #### CDC * Enables `ysql_enable_pg_export_snapshot` by default and exposes it as a YSQL configuration parameter. {{}} * Reduces unnecessary master load by not populating `backend_xmin` in `pg_stat_get_activity`. {{}} * Enhances system performance by preventing unnecessary RPCs to the yb-master in `pg_stat_get_activity`. {{}} ### Bug fixes #### YSQL * Installing `pg_stat_monitor` now displays a beta warning. {{}} * Optimizes column fetching during scans by removing redundant work, enhancing performance. {{}} * Ensures accurate index updates in `INSERT ... ON CONFLICT` for partial indexes. {{}} * Fixes issues with placement wildcards and leader preferences in tablespaces. {{}} * Sets default `pg_upgrade` directory to `pg_upgrade_data` and allows configuration via `pg_upgrade_working_dir` flag. {{}} * Eliminates backend crashes during DDL aborts when transaction metadata is not set. {{}} * Ensures stats for range data types are restored after backup in YugabyteDB. {{}} * Fixes handling of concurrent DDL and DML operations for accurate snapshot application. {{}} * Removes tuple locks to prevent deadlocks during concurrent `ALTER TABLE`. {{}} * Prevents PostgreSQL backend crash by addressing a dangling reference issue. {{}} * Reinstates missing values restoration in backups, adding logs for schema mismatches. {{}} * Prevents deadlocks by removing locks from certain catalog tables during DDL operations. {{}} * Enhances error messages when dropping a table concurrently to be more informative. {{}} * Fixes parallel index scans on hash indexes to handle duplicate column issues. {{}} * Disallows SAOP merge in parallel queries to ensure result order consistency. {{}} * Fixes error when running parallel queries with append plans. {{}} * Fixes an issue with empty IN condition lists in parallel queries. {{}} * Fixes the unique constraint violation for ALTER statements in transactions. {{}} * Introduces separate flags to control DDL catalog bumping and negative caching. {{}} * Reverts a change to prevent crashes during certain table alterations. {{}} * Enhances reliability in parallel query execution by embedding metric structures directly. {{}} * Pushes down Levenshtein function as a storage filter for improved query performance. {{}} * Fixes a bug to ensure concurrent table creation doesn't fail in YSQL. {{}} * Prevents deadlocks during ANALYZE with concurrent DDL by using separate transactions. {{}} * Ensures all clockbound contexts synchronize at startup for consistent timing. {{}} * Eliminates a memory leak in YSQL's authentication process. {{}} * Enables session defaults to reset correctly during transactions via new packet protocols. {{}},{{}} * Fixed multiple issues related to YSQL index backfill, ensuring correct read-time during uniqueness check, and respecting IntraWriteId during duplicate value check. {{}},{{}},{{}},{{}} #### YCQL * Ensures YCQL truncate command waits for index tables as well. {{}} #### DocDB * Ensures XCluster stability by using `table_id` to populate `namespace_id` in metadata, preventing issues from namespace renames. {{}} * Changes error message to "Unable to find the leader" for clarity. {{}} * Disables graceful shutdown to prevent data corruption. {{}} * Fixes tablet split validation to handle 0x0000 as an empty key for hash partitions. {{}} * Fixes transactions to default to region-based locality during upgrades involving tablespace locality support. {{}} * Ensures successful cloning of altered databases by managing connection permissions during the operation. {{}} * Prevents data loss on followers during tablet splits by using MVCC for split operations. {{}} * Replicates DDLs with session variables to ensure consistency across clusters. {{}} * Uses full hybrid time for xCluster DDL queue polling, enhancing replication accuracy. {{}} * Ensures correct syntax in `CREATE INDEX` statements with special options like `colocation_id`. {{}} * Fixes `ysql_dump` to correctly handle vector indexes in colocated databases. {{}} * Increases the RPC timeout to 1 hour for `AddTableToXClusterTarget` tasks. {{}} * Prevents xCluster replication from halting when dropping an invalid index. {{}} * Fixes yb-admin corruption errors for tablet partitions by using the correct schema. {{}} * Reduces unnecessary VI_STATS logging in pg_client_session.cc. {{}} * Ensures PRIMARY KEY indexes process before UNIQUE indexes during ALTER operations to prevent double index creation. {{}} * Skips parent tablet in data dumps for colocated tables. {{}} * Fixes a race condition in `kPgSession` transactions to better detect deadlocks. {{}} * Adds a tool to fix incorrect namespace_id in tablet metadata {{}} * Enhances upgrade prechecks to detect pgcrypto conflicts, preventing PG15 upgrade errors. {{}} * Fixes self-deadlock issue during post-split compaction on tablets with vector indexes. {{}} * Ensures data integrity during snapshot restoration by flushing relevant files during checkpoint creation. {{}} * Fixes issue of xCluster context not clearing when running DDLs in different schema, preventing collisions with follow-up DDLs. {{}} * Initiates abort operation proactively on detecting that backend would not recover from commit failure, triggering early cleanup of transactions. {{}} * Resolved a regression issue in YCQL backup/restore that affected tables with a unique index by adjusting the schema version bumping logic. {{}} #### CDC * Fixes the issue where UPAM gets stuck for colocated tablets with indexes, ensuring continuity of CDC operations. {{}} * Adds checks to handle cases where `GetConsistentWALRecords` returns zero WAL records near request deadlines, improving reliability in partially streamed transactions. The change also enables `cdc_enable_savepoint_rollback_filtering` by default, ensuring better support for Savepoint/Rollback operations in CDC. {{}}

## v2025.2.1.0 - February 12, 2026 {#v2025.2.1.0} **Build:** `2025.2.1.0-b141` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.2.1.0/yugabytedb-2025.2.1.0-b141-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.2.1.0/yugabytedb-anywhere-2025.2.1.0-b141-third-party-licenses.html) ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2025.2.1.0-b141 ``` ### Highlights We're excited to announce the key features and enhancements in the 2025.2.1.0 release, designed to improve performance, usability, and management of your database environments. |

Feature

| Description | | :-------- | :---------- | | {{}}[xCluster automatic mode](/stable/deploy/multi-dc/async-replication/async-transactional-setup-automatic/#set-up-automatic-mode-replication) | Seamless automated replication of YSQL DDL changes across xCluster, eliminating the need to manually apply DDLs on both source and target clusters. This simplifies DDL operations and reduces management overhead.

**To use**: Enabled by default for universes running v2025.2.1 or later. | | {{}}[Replication origins](/stable/additional-features/change-data-capture/using-logical-replication/advanced-topic/#replication-origins) | Adds support for [PostgreSQL replication origins](https://www.postgresql.org/docs/15/replication-origins.html); track the origin of transactions to avoid infinite loops (A -> B -> A -> B -> A) in bi-directional CDC setups.

**To use**: Create replication origins using the `pg_replication_origin_create();` function before streaming changes from a replication slot. | | {{}}[Connection Manager enhancement](/stable/additional-features/connection-manager-ysql/ycm-setup/#configure) | Reduces latency using an authentication passthrough mechanism when acquiring new logical connections.

**To use**: Set the `ysql_conn_mgr_use_auth_backend` flag to false; contact {{% support-general %}} about whether setting this parameter is recommended for your workload. | ### New features |

Feature

| Description | | :-------- | :---------- | | {{}}[Write pipelining](/stable/reference/configuration/yb-master/#ysql-enable-write-pipelining) | Reduces latency for multi-region write operations by combining asynchronous raft replication and modified commit behavior.

**To use**: Disabled by default. Add the `ysql_enable_write_pipelining` flag to [preview flags](../../../reference/configuration/yb-tserver/#allowed-preview-flags-csv), and set the flag to true on yb-master and yb-tserver. | | {{}}[Extended pg_stat_statements metrics](/stable/launch-and-manage/monitor-and-alert/query-tuning/pg-stat-statements/) | Adds metrics including next seek, average peak memory usage, retries, round trips (RPCs), and rows scanned, for optimized query performance and enhanced observability.

**To use**: Enabled by default. | | {{}}[Geo-partitioned read replicas](/stable/explore/going-beyond-sql/tablespaces/#read-replicas) | Geo-partitioned universes now support read replicas, enabling configurations such as "keep three replicas in EU with an additional read-only replica in the US".

**To use**: Create tablespaces with read replica nodes using the `read_replica_placement` configuration option. | | {{}} [Bucket-based indexes](/stable/develop/data-modeling/bucket-based-index-ysql/) | Addresses write-path hotspots for ascending/descending indexes while maintaining optimal performance for order-based queries.

**To use**: Disabled by default. Set `yb_enable_derived_saops` to true and `yb_max_saop_merge_streams` to 64. | ### Change log

View the detailed changelog

### Improvements #### YSQL * Allows concurrent DDL operations in YSQL when object locking is enabled, enhancing performance and usability. {{}} * Refactors PgClientSession to streamline read time updates via `UpdateReadTime`. {{}} * Enhances debugging by logging the last DDL node tag regardless of `BEGIN` block presence. {{}} * Refactors hash permutations in PgGate to enhance memory management and support more complex query conditions. {{}} * Refactors hacky varno logic for clearer Explain output formatting. {{}} * Allows custom sort orders in index scans through SAOP merge planning. {{}} * Expands `yb_explain_hide_non_deterministic_fields` to cover additional EXPLAIN fields. {{}} * Enhances SAOP merge execution by using the optimal SAOP in scenarios with varied cardinalities. {{}} * Consolidates secondary index scan logic and streamlines class names for future enhancements. {{}} * Enables complex index scans with custom sort orders using SAOP merge execution. {{}} * Removes redundant checks in `PgClientSession` to streamline code execution. {{}} * Automatically adds equality conditions for generated columns and indexes based on dependency. {{}} * Automatically adds SAOP conditions for certain index columns to optimize merge sorts. {{}} * Optimized the postgres build process by removing the redundant and time-consuming install_wrapper.py. {{}} * Adds a deprecated YSQL configuration for toggling PG snapshot management. {{}} * Enables `ysql_yb_enable_ddl_savepoint_support` as a preview feature, ensuring stability for user trials in pre-production environments. {{}} * Separates default and session-based YSQL configuration parameters into different lists for better management. {{}},{{}} * Enhances authentication passthrough, ensuring YSQL connection correctness and reducing latency. {{}} * Added compiler errors to Odyssey build for improved compile-time checking. {{}} * Adds support for replication connection authentication in Auth Passthrough mode. {{}} * Logs `ysql_dump` output on script failure during DB cloning. {{}} * Reduces YSQL backend startup logging to only two useful lines. {{}} * Deprecated the g-flag `ysql_conn_mgr_max_phy_conn_percent` and introduced new g-flag `ysql_conn_mgr_reserve_internal_conns` for reserving connections for internal operations. {{}} * Fixes a memory leak in YSQL authentication pass-through. {{}} #### YCQL * Enables clearing the YCQL MetaData cache via the `yb-ts-cli` tool. {{}} #### DocDB * Adds the `ysql_clone_disable_connections` flag to allow YSQL database connections during cloning. {{}} * Enables detailed data and checksum dumps for tablets via new commands, aiding in consistency checks and troubleshooting. {{}} * Blocks `nextval` and `setval` functions in automatic replication mode. {{}} * Prevents xCluster replication issues by ensuring new schema versions are current. {{}} * Adds control for vector index inclusion in post-split compaction. {{}} * Checks tablet limits before starting the DB cloning process. {{}} * Now captures TCMalloc and MemTrackers stats in logs when root memtracker soft memory limit is exceeded, aiding in memory issues investigation. {{}} * Added tablet replica SST and WAL size to master UI and sorted tablets by partition key. {{}} * Enhances vector index checkpoints placement for tablet splitting. {{}} * Automatically deletes vector index directories when tablets are deleted. {{}} * Adds latency metrics for bloom filter operations, controllable via `rocksdb_collect_bloom_filter_time_metrics` flag. {{}} * Enhances block navigation accuracy and API access in `TwoLevelIteratorState`. {{}} * Reduces excessive logging in CDC service, transaction manager, and RocksDB operations. {{}} * Added new `/snapshots` endpoint to tserver UI displaying space overhead information of snapshots, including snapshot ID, time, cumulative required space, exclusive data space, and schedule ID. {{}} * Reenables LogReader memory limit in xCluster following resolution of TryConsume bug. {{}} * Disables table locks to prevent potential test failures. {{}} * Eliminates redundant logic for child tablet registration, enhancing system consistency. {{}} * Enables manual tablet splitting for vector indexes. {{}} * Enables configuring read replicas at the tablespace level, enhancing data access flexibility. {{}} * Ensures more balanced tablet splits by calculating the middle key from user data only. {{}} * Prevents false deadlocks by not reusing transactions that have blocked others. {{}} * Allows running DDLs without aborting active transactions when table locks are enabled. {{}},{{}},{{}} * Enhances debugging and fixes a bug in RWCLock logging. {{}},{{}} * Sets yb_hnsw as the default backend for vector indexes. {{}} * Prevents sending of `YBParsePrepareErrorResponse` packet for unnamed prepared statements. {{}} * Ensures connection stickiness when using `pg_replication_origin_session_setup`. {{}} * Enhancements to GUC default values, especially GUC settings from startup packet. {{}} #### CDC * Added runtime flag to control CDC with Savepoints and Rollback feature, and introduced tests for rollback and savepoint behavior. {{}} * Allows CDC streaming from tables without a primary key using a new flag. {{}} * Captures `origin_id` from PostgreSQL sessions, enhancing CDCSDK handling of WAL records for distributed transactions. {{}} * Reduced logging levels in `CatalogManager::FindXReplStreamsMarkedForDeletion` when a table is dropped. {{}} ### Bug fixes #### YSQL * Enhanced handling of empty strings in CatalogEntityPB to prevent parsing failures during table entry deletion. {{}} * Fixed an issue where integer overflow in the new cost model could lead to negative cost estimates, resulting in poor plan choices. {{}} * Disallowed Batched Nested Loop joins when the inner relation is a temporary table to prevent cache lookup errors or assertion failures. {{}} * Adjusted `CatalogManager::GetYsqlCatalogConfig` to use `catalog_version_table_in_perdb_mode_` over `FLAGS_ysql_enable_db_catalog_version_mode` for accurate per-db mode representation. {{}} * Implemented statement timeouts and interrupt checking in pggate, providing an upper bound for query or operation time and terminating if deadline is reached. Deprecated the unused gflag `pggate_rpc_timeout_secs`. {{}} * Fixes quoting for unique constraints during schema restores. {{}} * Allows users to disable both DDL atomicity and transactional DDL simultaneously. {{}},{{}} * Updates process exit behavior on pggate heartbeat failure during initialization. {{}} * Fixed a bug in YugabyteDB's backup and restoration process involving the mismatch of colocation_id in colocated databases. The fix preserves the original colocation_id when implicit indexes are created during the ALTER TABLE statement, ensuring that the colocation ids are consistent after restoration. {{}} * Fixed an issue where running ALTER TYPE on a table with dependent indexes triggered double index creation, causing replication conflicts on xCluster targets. {{}} * Enhances stability during transaction rollbacks involving index and base table deletions. {{}} * Fixes race condition in `ROLLBACK TO SAVEPOINT` handling for DDLs. {{}} * Ensures replaced trigger functions are used correctly in transactions. {{}} * Ensures that newly created or updated functions are correctly recognized and replace stale versions in YSQL. {{}} * Prevents crashes during transaction abort when an ALTER TYPE command fails with transactional DDL enabled. {{}} * Reinstates missing values restoration in backups, adding logs for schema mismatches. {{}} * Fixes are introduced to address intra-query memory leaks during long-running write queries, reducing transient memory spikes and improving memory allocation. {{}},{{}} * Changes `yb_make_all_ddl_statements_incrementing` to a test YSQL configuration parameter to prevent DDL failures. {{}} * Fixes vector indexes to support `ysql_use_packed_row_v2` flag, preventing data corruption. {{}} * Fixed an issue with prepared statements on temporary tables when using extended query protocol. {{}} * Fixes crashes during savepoint rollback for the first DDL in transactions. {{}} * Fixed a metadata correctness bug that caused errors when using minimal preloading with negative caching. {{}} * Prevents unnecessary request dispatches for out-of-bound hash permutations. {{}} * Ensures hash permutations reset correctly for parallel queries on hash-distributed tables. {{}} * Restored legacy mode costing and path creation behavior in YSQL. This is achieved by reverting BNL specific changes and negating a side effect on row count estimation introduced by boolean index fix. {{}} * Fixes "schema version mismatch" errors after savepoint rollbacks. {{}} * Ensures each batch has sufficient PgsqlOps/ReadReqs to avoid segmentation faults. {{}} * Fixed read restart error occurring during concurrent execution of CREATE TEMP TABLE. {{}} * Skips tables in DELETING or DELETED state during rollback to savepoint to prevent errors. {{}} * Fixed a missing build dependency issue in the yb_pgwrapper library that caused a failure when running build with clean-postgres. {{}} * Prevents database crashes by skipping cache invalidation for negative entries. {{}} * Ensures all read restart errors display complete debugging information in the detail message. {{}} * Adds GFlag for GUC yb_ignore_bool_cond_for_legacy_estimate, allowing setting via GFlag before upgrading from 2.20. {{}} * Ensures object lock acquisition deadlines are computed in microseconds, preventing rounding errors for sub-second timeouts. {{}} * Ensures functions remain accurate after rolling back to a savepoint. {{}} * Adds synchronization wait time to prevent crashes on startup in clockbound mode. {{}} * Fixes crashes during complex row comparisons in YSQL queries. {{}} * Reduces redundant lock requests in YSQL, speeding up certain DDL operations. {{}} * Limits request and response sizes in YSQL ANALYZE to avoid errors. {{}},{{}} * Adds `yb_ycql_utils` to supported extensions for YSQL major upgrades. {{}} * Fixed issue where server connection gets stuck due to full server write buffer after ungraceful client disconnects. {{}} * Implemented a fix to remove stale entries from the server's hashmap during connection manager reset phase. {{}} * Fixed the Connection Manager's support for replication connections, ensuring that it independently manages these connections, aligning with PostgreSQL's behavior. {{}} * Reduces CPU usage in connection manager by improving `epoll_*` functions and fixing syntax errors. {{}} * Ensures accurate index updates in 'INSERT ... ON CONFLICT' for partial indexes. {{}} #### YCQL * Enables retrying YCQL analyze steps for `OBJECT_NOT_FOUND` errors to refresh cache. {{}} * Prevents crashes by correctly handling NULL index references in YCQL queries. {{}} #### DocDB * Enhances `rocksdb_bytes_read` metric to include iterator read bytes. {{}} * Fixed deadlock in MasterSnapshotCoordinator by modifying PopulateDeleteRetainerInfoForTableDrop to pass table_info to IsTabletCoveredBySnapshot. {{}} * Reduces log replay during bootstrap by synchronizing intents DB flushed op ID with regular DB. {{}} * Prevents duplication of restoration requests in tablet metadata. {{}} * Enables `ysql_dump` with `read-time` option for consistent point-in-time backups. {{}} * Eliminates race conditions between snapshot creation and concurrent DDL operations. {{}} * Enhances xCluster by ensuring indexes are replicated with associated table DDLs. {{}},{{}} * Fixes vector index searches to return complete results post-tablet splits. {{}} * Prevents failures in simultaneous table creations across different databases in the same replication group. {{}} * Fixes a TServer crash issue during hybrid scans caused by incorrect read requests from Postgres. {{}} * Ensures batched `COPY` operations securely re-acquire table and index locks, reducing partial copy failures. {{}} * Prevents race conditions during YSQL lease re-acquisition by synchronizing it with lock requests. {{}} * Fixes bugs in Prometheus metrics scraping for tables with special characters in their names. {{}} * Prevents fatal errors in transactions by relaxing subtransaction checks. {{}} * Switched from using SIGQUIT to SIGINT to stop the PostgreSQL postmaster, preventing core dump generation at TServer startup. {{}} * Prevents shutdown errors by checking for active tasks during registry closure. {{}} * Enhances xCluster DDL replication by including schema names in relation maps. {{}} * Ensures all tablets have updated schemas for xCluster replication, improving error handling and consistency. {{}},{{}} * Introduces `min_replay_txn_first_write_ht` to address transaction data loss that occurred due to incorrect filtering of transactions on bootstrap. {{}} * Eliminates false conflicts in fastpath object locking by replicating PostgreSQL's matrix. {{}} * Automatically cleans up discarded checkpoints to prevent disk full issues during remote bootstraps. {{}} * Enhances xCluster replication by skipping unnecessary tuple generation in `ATRewriteTable`. {{}} * Adds logging for database creation and deletion events in `ysql_db_catalog_version_map`. {{}} * Allows xCluster DDL replication setup with materialized views. {{}} * Resolved a race condition between server shutdown and tablet cleanup by moving startup tablet cleanup to a background thread and adding a check to avoid crashes if shutdown is in progress. {{}} * Fixes a process crash that could occur during unique index checks due to incorrect functioning of DBIter's fast next mode with backward iteration. {{}} * Disables inline waiting for PG connections on cluster start with object locking. {{}} * Ensures `yb_index_check` correctly acquires object locks, preventing debug assertion failures. {{}} * Switched from using SIGKILL to SIGQUIT and SIGINT for stopping postmaster process during lease loss and tserver shutdown respectively. {{}} * Implemented root memtracker adjustment to limit deviation from TCMalloc stats, avoiding overestimation and false triggering of memory limits. {{}} * Adjusts object locking sanity checks to transaction level granularity. {{}} * Ensures consistent behavior across sessions during upgrades by caching table lock flag values. {{}} * Fixes transaction-related DFATAL issues by enabling concurrent updates. {{}} * Disables tablet splits during table hide operations to prevent state inconsistencies and lock leaks. {{}} * Enhances isolation test coverage by adding `partition-drop-index-locking` and adjusting `timeouts` to align with PostgreSQL behavior. {{}} * Ensures vector index searches function correctly across sessions. {{}} * Enables Postgres to function with `node_to_node_encryption_use_client_certificates` flag. {{}},{{}} * Automatically resets stale transaction IDs on transaction failure to prevent lock leaks. {{}} * Ensures DDL operations wait when DML is in progress with object locking. {{}} * Disables object locking for `yb_proc_schedule` to ensure consistent test outputs. {{}} * Disables intent filtering for bootstrap due to transaction filtering issues with use_bootstrap_intent_ht_filter set to true. {{}} * Supports successful backups during tablet splits. {{}} * Excludes invalid indices from snapshots to prevent backup restore failures. {{}} * Ensures accurate schema during backups amid concurrent schema alterations and snapshot creations. {{}} * Reduces `TServer does not have a live lease` errors for pg clients by adding retry logic. {{}} * Prevents potential double decrement errors in object lock state management. {{}} * Prevents restore failures during schema merges in backups taken during DDL operations. {{}} * Reduces lock overflow issues by treating redundant lock requests as no-ops. {{}} * Fixes a regression that allowed restoring to a time earlier than the maximum retention window, potentially causing database instability. {{}} * Ensures correct resetting of the wait state in the WAL appender thread. {{}} * Adds a null check to prevent indefinite wait states in WAL appender threads. {{}} * Prevents fatal errors by storing status tablet data for global object lock requests. {{}} * Fixes yb-admin corruption errors for tablet partitions by using the correct schema. {{}} * Maintains correct message order by buffering ParameterStatus updates. {{}} * Enables hot certificate reloading for client-to-node encryption. {{}} * Handles sync timeout more effectively during connection resets. {{}} * Resolves Bind packet forwarding issue for unnamed prepared statements. {{}} * Fixes a potential segfault when handling auth errors in Auth Passthrough mode. {{}} * Eliminated potential TCP deadlock in YSQL by changing to asynchronous write in `od_frontend_remote_client`. {{}} * Truncate user and database names exceeding 64 characters to prevent buffer overflow during startup. {{}} * Modified `od_write` function to prevent double free of `mm_msg_t` objects and enhanced `machine_msg_free` to handle NULL messages. {{}} * Resolved rounding errors in `StopWatch` by changing calculation order. {{}} * Stops empty sample blocks from being incorrectly counted in analytic calculations. {{}} * Disables graceful shutdown to prevent data corruption in 2025.2.1. {{}} * Increases the RPC timeout to 1 hour for `AddTableToXClusterTarget` tasks. {{}} * Ensures PRIMARY KEY indexes process before UNIQUE indexes during ALTER operations to prevent double index creation. {{}} * Fixes tablet split validation to handle 0x0000 as an empty key for hash partitions. {{}} #### CDC * Fixed error in UpdatePeersAndMetrics for Sys Catalog tablet, improving handling of `pg_publication_rel` and `pg_class` tables. {{}} * Fixes endpoint verification failures by using DNS hostnames for local connections. {{}} * Fixes UPAM stalling with colocated tablets containing indexes, preventing CDC errors. {{}}

## v2025.2.0.1 - January 26, 2026 {#v2025.2.0.1} **Build:** `2025.2.0.1-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.2.0.1/yugabytedb-2025.2.0.1-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.2.0.1/yugabytedb-anywhere-2025.2.0.1-b1-third-party-licenses.html) ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2025.2.0.1-b1 ``` ### Bug fix #### DocDB * Disables graceful shutdown to prevent data corruption. {{}} ## v2025.2.0.0 - December 11, 2025 {#v2025.2.0.0} **Build:** `2025.2.0.0-b131` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.2.0.0/yugabytedb-2025.2.0.0-b131-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.2.0.0/yugabytedb-anywhere-2025.2.0.0-b131-third-party-licenses.html) ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2025.2.0.0-b131 ``` ### Highlights **PostgreSQL features enabled by default on new universes** For new universes running v2025.2 or later, the following YSQL features are now enabled by default when you deploy using [yugabyted](../../../deploy/manual-deployment/start-yugabyted/), [YugabyteDB Anywhere](../../../yugabyte-platform/create-deployments/create-universe-multi-zone/), or [YugabyteDB Aeon](../../../yugabyte-cloud/cloud-basics/create-clusters/) (coming soon to the Early Access track): * [Read committed](../../../architecture/transactions/read-committed/) * [Cost-based optimizer](../../../best-practices-operations/ysql-yb-enable-cbo/) * [Auto Analyze](../../../additional-features/auto-analyze/) * [YugabyteDB bitmap scan](../../../reference/configuration/postgresql-compatibility/#yugabytedb-bitmap-scan) * [Parallel append](../../../additional-features/parallel-query/) In addition, if you upgrade to v2025.2 and the universe already has cost-based optimizer enabled, the following features are enabled by default: * Auto Analyze * YugabyteDB bitmap scan * Parallel append Note that, apart from the exceptions noted, upgrading existing universes does not change the defaults for any of these features. For more information on PostgreSQL features developed in YugabyteDB for enhanced compatibility, refer to [Enhanced PostgreSQL Compatibility Mode](../../../reference/configuration/postgresql-compatibility/). **Table-level locking for concurrent DDL and DML** {{}} Added [Table-level locks](/stable/explore/transactions/explicit-locking/#table-level-locks) to support concurrent DDL and DML operations across sessions, improving workload concurrency and reducing conflicts during schema changes. **Improved time synchronization across nodes** {{}} Time synchronization across nodes has been enhanced through the use of the [ClockBound](https://github.com/aws/clock-bound) library, which is an open source daemon that allows you to compare timestamps to determine order for events and transactions, independent of an instance's geographic location; it improves clock accuracy by several orders of magnitude. For more information, refer to [ClockBound](/stable/deploy/manual-deployment/system-config/#configure-clockbound). ### New features * Improves [cluster balancer](/stable/architecture/docdb-sharding/cluster-balancing/#monitoring-cluster-balancer-progress) observability and throughput by prioritizing recovery of leaderless tablets. {{}} * Added [CDC Logical Replication support](/stable/additional-features/change-data-capture/using-logical-replication/get-started/) for xCluster feature where both CDC and xCluster can work simultaneously on the same source tables. {{}} * ASH * Adds [ASH](/stable/launch-and-manage/monitor-and-alert/active-session-history-monitor/) instrumentation to CDC, xCluster, Remote bootstrap, Restore Master, and Connection pooling for better bottleneck identification. {{}} * Adds `rss_mem_bytes` field to `yb_active_session_history` for tracing high memory sessions. {{}} * [Colocated tables with tablespaces](/stable/additional-features/colocation/#colocated-tables-with-tablespaces). With this enhancement, you can now take advantage of colocated tables for geo-distributed use cases, eliminating the need for trade-offs between distributing data across specific regions. {{}} * Enhances bulk load performance on distributed tables by implementing Skip Prefix Locks. {{}} * [Auto Analyze service](/stable/additional-features/auto-analyze) Added automatic background statistics gathering to improve usability by eliminating the need for users to manually run ANALYZE. {{}} * Enhance tablet server write RPC visibility with [EXPLAIN plan](/stable/api/ysql/the-sql-language/statements/perf_explain) to identify bottlenecks and potential optimizations. {{}} * [Cluster tablet metadata](/stable/explore/observability/yb-tablet-metadata/) Offers a global view, `yb_tablet_metadata` to reveal tablet placement, leadership, and row-specific information for all tables and databases. {{}} * [Backups with DDL](/stable/manage/backup-restore/). Backups succeed even when DDL changes are occurring during the backup process. {{}} * Support pgvector extension - With indexing support {{}}. Brings AI-native capability by supporting pgvector with indexing, enabling efficient similarity search in vector workloads. Enhances vector search capabilities by introducing [Hierarchical Navigable Small World (HNSW) indexing](/stable/additional-features/pg-extensions/extension-pgvector/#vector-indexing), enabling faster and more efficient high-dimensional vector lookups. * Expands ALTER TABLE functionality to include new and ongoing requests. {{}} * Simplifies ongoing and new tasks in the Catalog Caching area excluding main projects like Hybrid Tables/per-node-catalog cache. {{}} * Enhances query execution with foreign key performance, further IN batching, distinct and domain type pushdown improvements. {{}} * Introduces transaction-related enhancements for v2025.2, fixing consistency issues and read-restart errors. {{}} * Removes table tombstone check for colocated tables, increasing read and write performance. {{}} * Changes default [password encryption](/stable/secure/authentication/password-authentication/) from `md5` to `scram-sha-256` for new clusters without requiring extra steps. {{}} ### Change log

View the detailed changelog

### Improvements #### YSQL * Ensures YSQL index backfill operations resume seamlessly after a master leader failover. {{}} * Disallows interleaving SAVEPOINT and DDLs in a transaction block if transactional DDL is enabled, ensuring the safe execution of DDLs in Read Committed (RC) isolation. {{}} * Fixes a use-after-free bug in postponed DDL operations to prevent potential issues in transaction commits. {{}},{{}} * Allows setting and modifying options for foreign tables using `ALTER FOREIGN TABLE ...OPTIONS (...)`. {{}} * Allows execution of multiple `TRUNCATE` statements within the same sub-transaction without causing errors. {{}},{{}} * Simplifies handling of temporary tables with on-commit actions by committing the DocDB transaction after executing these actions, preventing errors related to unnecessary transaction states. {{}},{{}} * Fixes the `ANALYZE` command error occurring when run outside of a transaction block, ensuring smoother operations. {{}},{{}} * Resolves a bug in DDL atomicity workflow that incorrectly committed transactions involving table creation and deletion in the same block, preventing PG and DocDB schema divergence. {{}},{{}} * Enables configuration of transactional DDL blocks via the `yb_ddl_transaction_block_enabled` flag. {{}},{{}} * Resets the DDL state for read-only transactions to avoid state persistence issues. {{}},{{}} * Introduces the `yb_fk_references_cache_limit` parameter to cap FK references cache entries at 65535. {{}} * Allows specifying colocation option for parent partition tables and splits parent partition tables into a single tablet. {{}},{{}} * Enables transactional Data Definition Language (DDL) as a regular flag for interleaving DDL and Data Manipulation Language (DML) statements within a transaction block, enhancing system catalog read/write operations. {{}} * Enables transactional DDL in YSQL, allowing DDLs to run within a transaction block and interleave with DML operations, while ensuring DDL atomicity. {{}},{{}} * Enables speculative execution for certain PL statements to avoid unnecessary flushes, enhancing performance. {{}} * Simplifies control flags for the auto analyze service, merging two existing flags into one, easing the use of the auto analyze feature. {{}} * Reduces the frequency of auto-analyze on small, frequently-updated tables. {{}} * Supports executing DDL statements in READ COMMITTED isolation with options to disable retries. {{}} * Adds extra locality info from PostgreSQL to TServer for better transaction categorization and performance. {{}} * Add a new YSQL configuration parameter that allows all DDL commands to increase the catalog version. {{}} * Reduces catalog cache memory spikes during new connections by introducing a TriggerRelcacheInitConnection RPC that allows only superuser `postgres` to rebuild the relcache init file. {{}} * Limits relcache init file rebuilding to internal connections only, reducing the memory spike associated with new connections. {{}} * Adds debug logs to help diagnose errors when rebuilding the relcache init file. {{}} * Reduces potential catalog cache memory spikes by enabling internal connections to perform minimal catalog preload. {{}} * Adds a lint rule to ensure the pairing of `Form_*` and `FormData_*` lines in yb_typedefs.list, increases code readability, and updates yb_typedefs.list and yb_thirdparty_typedefs.list. {{}} * Adds support for deferred mode in `yb_read_after_commit_visibility` for writes. {{}} * Adds estimated roundtrip counts to EXPLAIN output for scans. {{}} * Adds support for LSM index creation on multirange columns. {{}} * Displays write RPC metrics in `EXPLAIN (ANALYZE, DIST, DEBUG)` output. {{}} * Logs now detail the cause and context of read restart errors for better troubleshooting. {{}} * Adds a new YSQL parameter `yb_enable_cbo` for safer query optimization without statistics. {{}} * Enables integration of YSQL with PG snapshot management for Repeatable Read isolation level. {{}} * Introduces a per-backend in-memory cache for the hints table in the `pg_hint_plan` extension, reducing query planning time by avoiding inter-node lookups for each query execution. {{}} * Adds YB-specific counters to `pg_stat_statements` for detailed stats tracking. {{}} * Re-imports latest commit files from yb-pg15 branch, cherry-picks YB commits, removes unneeded commits, updates ysql_bench metrics, and fixes other minor issues. {{}} * Simplifies code management by separating cancelable and non-cancelable scopes. {{}} * Refactors the PgGate fetch control, introduces new classes for combining results from multiple PgsqlOp objects, optimizes index scan read requests for co-partitioned vector indexes, and removes unnecessary index requests. {{}} * Limits output buffer to 8kB to ensure compatibility with certain clients. {{}} * Enhances TServer by adding support for garbage collection of invalidation messages, reducing memory usage. {{}} * Enhances accuracy of cost modeling for backward index scans based on the `use_fast_backward_scan` flag. {{}} * Updates the `pg_stat_statements` header to reset stats on upgrade from 2.25 to 2.27. {{}} * Enhances PostgreSQL logging integration by utilizing the ErrorData.backtrace field, adjusting the control of backtrace addition through the `backtrace_functions` parameter, and introducing a `yb_debug_original_stacktrace_format` flag to switch stacktrace formats. {{}} * Increases the timeout for detecting `pg_yb_catalog_version` mode from 10 seconds to 20 seconds. {{}} * Streamlines UPDATE/DELETE operations and standardizes function signatures in YSQL. {{}} * Allows DDL statements to update the shared catalog version, reducing unnecessary master RPC calls and improving performance. {{}} * Prevents auto-analyze DDLs from blocking or preempting user DDLs. {{}} * Removes unnecessary YB_TODO comment in pl_exec.c related to memory context lifespan. {{}} * Optimizes catalog version updates on DDL statements to avoid unnecessary refreshes. {{}} * Adds support for `cube` and `earthdistance` extensions in YSQL upgrades. {{}} * Adds a new YSQL configuration parameter to disable the hint table cache. {{}} * Allows cleaner and when-needed building of dummy_seclabel in build_postgres.py instead of adding it as a default subdirectory. {{}} * Reduces unnecessary full catalog cache refreshes by calling update functions atomically. {{}} * Streamlines the database by removing obsolete functions related to drop/remove object by OID. {{}} * Removes the `YB_BITMAP_DISCOURAGE_MODIFIER` to better reflect actual bitmap scan costs. {{}} * Enhances the function to find the first catalog version more quickly using `std::lower_bound` instead of a linear scan. {{}} * Updates the yb_pgindent run and fixes some related issues for better code style and format. {{}} * Removes unused macro CHECK_REL_PROCEDURE2 and cleans up obsolete YB_TODO in heapam/indexam. {{}} * Automates directory switch and indent option computation in yb_pgindent to simplify usage. {{}} * Removes a redundant YB_TODO comment in finalize_partialaggregate that was introduced during the PG 15.2 initial merge. {{}} * Adjusts the bad_variable_declaration_spacing lint rule to ignore macros and exclude certain paths, enhancing code consistency. {{}} * Removes obsolete tasks in pg_dump.c, enhancing initial privileges retrieval for extension objects during backup/restore. {{}} * Skip lint rules for certain files, reducing warnings/errors and simplifying exclusion logic. {{}} * Removes a duplicate and outdated recordDependencyOnTablespace, enhancing the initial merge process. {{}} * Adds `pss_mem_bytes` field to `yb_active_session_history` for tracking process memory usage. {{}} * Enables sending buffered write operations and multiple read operations in a single RPC for optimized performance. {{}} * Allows setting the flag `ysql_yb_enable_invalidation_messages` to disable incremental catalog cache refresh. {{}} * Enables setting `ysql_yb_enable_cbo` flag on TServer for query optimization. {{}} * Switches to `__thread` in regex code for thread-local variables, ensuring correctness and safety in multi-threaded environments. {{}} * Allows YbctidReaderProvider to work with Slice instead of std::string for optimized PgFKReferenceCache memory usage. {{}} * Enables parallel scanning in all safe cases, thereby enhancing speed and performance. {{}} * Reduces unexpected full catalog cache refreshes in new PG backends. {{}} * Allows turning a stored generated column into a normal one with ALTER TABLE ALTER COLUMN DROP EXPRESSION. {{}} * Adds verbose logging for Perform RPCs between Pg and TServer via shared memory. {{}} * Modifies the `bad_comment_style` rule to bypass lint errors for nested comments in `d2s_intrinsics.h` and `d2s.c` files. {{}} * Adjusts lint rule to ignore false positives for pg_hint_plan comments inside string. {{}} * Rectifies PostgreSQL lint rule bad_spacing_after_comment violations and upgrades it from warning to error. {{}} * Enhances brace lint rules to ignore false positives from code comments and macros, and upgrades them from warnings to errors. {{}} * Enhances logging for troubleshooting unexpected full catalog refreshes by adding `CatalogInvalMessagesDataDebugString`. {{}} * Displays storage flush reasons under debug logs for better query performance analysis. {{}} * Simplifies conditional cleanup actions with `MakeOptionalScopeExit` function. {{}} * Replaces the `rss_mem_bytes` column in `pg_stat_activity` with `pss_mem_bytes` for more accurate memory measurements. {{}} * Removes the beta label for various Foreign Data Wrapper commands in YSQL. {{}} * Streamlines request pagination in scans for consistent behavior across all directions. {{}} * Allows `upgrade_ysql` to exit early if YSQL is not enabled. {{}} * Adds `GUC_EXPLAIN` flag to YB-specific GUC parameters for enhanced EXPLAIN output. {{}} * Simplifies code for `Perfrom` requests, enhancing readability and usability. {{}} * Optimizes table cache by using invalidation messages to clear only relevant entries, reducing OpenTable RPC count. {{}} * Displays TCMalloc and PGGate memory stats in `pg_log_backend_memory_contexts` for enhanced debugging. {{}} * Introduces `hnsw.ef_search` as a new YSQL configuration parameter, mirroring `ybhnsw.ef_search`. {{}} * Displays read operations in EXPLAIN for better insight into the number of operations, unaffected by request parallelism. {{}} * Reduces memory allocations by using a generator instead of non-reused vectors in `PgDmlRead::SetHoldingRequestedYbctids` method. {{}} * Enhances row boundary settings for hash-partitioned tables using encoded DocKeys. {{}} * Adds the ability to display commit stats with the EXPLAIN command, helping users understand latency in multi-region workloads. {{}} * Introduces a new yb_tablet_metadata view that allows users to fetch tablet distribution and leadership information across the entire cluster. {{}} * Simplifies the PgTableCache interface reducing boilerplate code by accepting a single shared pointer of type PgTablesQueryTableReceiver instead of two independent pointers. {{}} * Simplifies adding types to yb_typedefs.list and running yb_pgindent. {{}} * Enables the `now` function to be evaluated once, replaced with a constant, and pushed down to DocDB, enhancing query execution. {{}} * Ensures all `COPY FROM` commands in a transaction block use one transaction unit. {{}} * Adds a new column to the yb_wait_event_desc view for more context about wait events. {{}} * Reduces master load by allowing auth backends to utilize the TServer cache during authorization checks. {{}} * Includes transaction isolation level in serialization error messages. {{}} * Simplifies query handling via shared exchange by substituting `callback` in `PgClientData` with `std::promise`, saving memory allocation. {{}} * Set YSQL configuration parameter `yb_read_after_commit_visibility` to `relaxed` to avoid `restart read required` errors during yb_index_check. {{}} * Enables bounded staleness for PostgreSQL authentication backend cache using `pg_cache_response_trust_auth_lifetime_limit_ms`. {{}} * Reduces master RPCs for PG auth backends by using TServer cache. {{}} * Allows dynamic updates to `ysql_hba_conf_csv` without server restarts. {{}} * Reduces chances of multiple notifications to listeners when opening multiple tables concurrently by refining the `Waiter` helper class. {{}} * Adds functionality to the three extra columns in pg_stat_statements for tracking query retry counts. {{}} * Allows altering table constraints using the new `ALTER TABLE` syntax. {{}} * Reduces memory usage by limiting the collection of intents in PgFKReferenceCache to the max batch size. {{}} * Adds new RPC stats to pg_stat_statements and introduces a new flag `yb_enable_pg_stat_statements_rpc_stats` for capturing RPC wait times. {{}} * Allows VERBOSE output in YSQL configuration parameter `yb_explain_hide_non_deterministic_fields` mode. {{}} * Shifts documentdb build logic to a dedicated Makefile for more reliable checks during building process. {{}} * Add a new counter to track new connections performing catalog preloads, aiding in debugging. {{}} * Introduces `DEBUG_ONLY` macros to keep debug injection code compact and improve readability. {{}} * Refactors YbcFlushDebugContext to reduce copying and fix pgindent errors by passing it as a pointer. {{}} * Updates copyright format to match the most current version, "...YugabyteDB, Inc.", across all files. {{}} * Refactor YbRunWithPrefetcher code to avoid errors when running yb_pgindent and improve code formatting. {{}} * Avoids unnecessary memory spikes and ensures freshest catalog data for relationship cache initialization. {{}} * Adds new YSQL configuration parameter `yb_enable_cbo=legacy_ignore_stats_bnl_mode`. {{}} * Adds support for `docdb_rows_returned` column in pg_stat_statements to count rows returned by the storage layer. {{}} * Expands EXPLAIN (ANALYZE, DIST) output to include transaction type, enabling a more formal way to deduce transaction type. {{}} * Allows pushdown of stable and parameterless SQL Value Functions as storage filters. {{}} * Increases timeout for TServer catalog version wait to 30 seconds, reducing connection time outs. {{}} * Enables Early Access to Query Diagnostics from 2025.2. {{}} * Allows preloading of RANGEMULTIRANGE to reduce cache misses when pg_range is preloaded. {{}} * Fixes `pg_total_relation_size` to include index sizes, ensuring accurate and consistent size reporting across YugabyteDB's distributed storage. {{}} * Adds a new `ysql_userid` column to Active Session History to track user activity and query performance. {{}} * Reduces peak memory usage in yb_active_session_history by filtering out rows more quickly. {{}} * Adds variable bloom filter support for queries with multiple keys, enhancing efficiency during scan operations. {{}} * Cleans up YbBindSearchArray, enhancing code efficiency and preparing for future bucketized index work. {{}} * Auto analyze flag now defaults based on user-set cost-based optimizer (CBO) flags, reducing bad combinations. {{}} * Adds a check to prevent autonomous DDL transactions during an active regular transaction block. {{}} * Simplifies type conversions in index backfill code to enhance consistency and prevent potential overflow. {{}} * Adds four transaction-specific wait events to Active Session History for better operation tracking. {{}} * Disables Memoize under BNL to reduce CPU overhead without sacrificing performance. {{}} * Reduces race conditions in DROP DATABASE operations by waiting for stats update in Connection Manager. {{}} * Adds a flag `ysql_enable_scram_channel_binding` to enable SCRAM with channel binding. {{}} * Reduces query execution latency by optimizing GUC handling in Connection Manager. {{}} * Introduces a flag to enable or disable the import of stats during `pg_upgrade`, reducing memory usage and enhancing performance. {{}} * Adds a flag to simulate DDL operations during YSQL major upgrade. {{}} * Added a built-in utility, `yb_index_check()` that helps detect and diagnose index inconsistencies in your database to ensure reliable query results. #### YCQL * Removes unused code that allows changing the table namespace, simplifying the source code. {{}} #### DocDB * Tracks ByteBuffer memory usage with `MemTracker`. {{}} * Adds data block consistency check to `sst_dump` tool. {{}} * Adds flag to allow tablet writes after a compaction failure. {{}} * Adds `remove_corrupt_data_blocks_unsafe` flag for `yb-ts-cli compact_tablet` command. {{}} * Ensures only voter peers are considered for leadership during a leader stepdown. {{}} * Removes outdated fields from RaftGroupReplicaSuperBlockPB to avoid confusion, ensuring safe upgrade and rollback. {{}} * Fixes overflow in `FormatBytesAsStr` to prevent large memory allocations. {{}} * Adjusts the `wal_size` metric to include the size of the current active, writable segment, ensuring accurate reflection of on-disk size. {{}} * Changes default value of `ysql_num_tablets` to 1 for initial number of tablets in hash partitioned tables. {{}} * Adds logging to detect and inform if scheduled tasks in the reactor run slower than expected. {{}} * Optimizes index scans by adaptively deciding to use `next` or `re-seek`, reducing query latency. {{}} * Reduces load balancer's hold on `CatalogManager::mutex_` to prevent potential master leader unavailability. {{}} * Prevents data loss during early compaction of replicated colocated tables. {{}} * Introduces asynchronous lock functionality in ObjectLockManager to avoid holding up RPC threads during conflicts, and includes deadlock detection. {{}} * Allows DDL release operations to withstand master restarts or failovers and ensures successful execution of release requests even when network issues occur. {{}},{{}} * Enhances table locking by propagating lock calls to the TServer and expanding lock acquisition to all objects. {{}} * Displays RBS progress details on the master's Cluster Balancer UI page. {{}} * Introduces a debug tool to release global/exclusive table locks via yb-admin command, assisting in managing unexpected lock leaks. {{}} * Support now correctly captures table IDs and colocation IDs during DDL replication, ensuring accurate replication for unique constraints, partitioned indexes, and table rewrites. {{}},{{}} * Allows outstanding transactions to continue during DDL operations when table locks are enabled. {{}} * Allows tracking of table-level lock states across all nodes, with accurate reporting in the pg_locks view. {{}} * Triggers automatic background compaction for vector index based on size amplification, using the `vector_index_max_size_amplification_percent` flag. {{}} * Sets `xcluster_backfill_hybrid_time` for all indexes to ensure no missed rows during backfill after data insert. {{}} * Upgrades OpenSSL to version 3.0.16 and enhances aarch64 support. {{}} * Disables statement retries when object locking feature is on, due to lack of re-acquisition of object locks during retries in extended query mode. {{}} * Ensures consistent xCluster safe time during failover, including executed DDLs, by pausing all pollers and updating the safe time accordingly. Avoids issues during normal scans and inconsistencies during failover. {{}} * Disables transparent statement retries in all paths when the object locking feature is activated. {{}} * Switches YSQL object lock calls to use shared memory, reducing overhead to 5-15%. {{}} * Allows seamless failover to the consumer cluster by using a variant of PITR that only restores data tablets, not pg catalog tables or yb master tablet. {{}} * Allows transaction status tablets to be grouped by tablespace for future categorization of transactions. {{}} * Ensures reliable xCluster history cutoff by backfilling `namespace_id` when necessary. {{}} * Adds support for tablespace-local localities, allowing transactions to use status tablets corresponding to a specific tablespace, improving data replication handling for geographically close regions. {{}} * Limits TServer crashes by capping log reader memory usage in xCluster replication. {{}},{{}} * Enables safe activation and deactivation of the skip prefix locks feature and allows for safe upgrades. {{}} * Allows control over the number of tasks running in parallel via the introduction of PriorityThreadPoolToken. {{}} * Control the number of vector index compactions per TServer with new flags, offering control over chunks taken for compaction and limiting running compactions per TServer. {{}} * Promotes object locking preview flag to a regular flag, allowing users to control the feature through the `enable_object_locking_for_table_locks` flag. {{}} * Adjust leader lease to be larger than the heartbeat interval to avoid unnecessary retries and latency. {{}} * Optimizes colocated table read performance by caching tombstone check results, making bulk updates 6x faster. {{}} * Adds a metric to monitor the wait time of write and remove threads in joining the write batch group. {{}} * Adds new wait events for ASH instrumentation to identify bottlenecks during bootstrap. {{}} * Integrates RWQueue for enhanced concurrent queue performance and introduces `TrivialSpinlock` for improved spinlock functionality. {{}} * Enables `ysql_yb_enable_advisory_locks` by default and makes it a runtime flag. {{}} * Enables cloning of vector indexes in databases. {{}} * Allow tablet server to wait for YSQL lease before starting postmaster, improving connection handling. {{}} * Adds paginated querying for vector index operations. {{}} * Allows setting `ybhnsw.ef_search` to customize search expansion factor. {{}} * Allows partial processing of DDLs during failover by incrementing xCluster safe time after each DDL replication. {{}} * Removes libcds dependency, simplifying threading model and reducing runtime costs. {{}} * Enforces shared memory access restrictions at compile time. {{}} * Cancels vector index compaction during VectorLSM shutdown. {{}} * Enables saving of in-memory HNSW graph data to file system, enhancing usability and efficiency. {{}} * Enables consistent backup and restore for vector indexes. {{}} * Replaces most instances of `LOG(ERROR)` with either `LOG(WARNING)` or `LOG(DFATAL)` to align with coding style. {{}} * Enables priority thread pool usage for vector index compactions. {{}} * Adds detailed logging for failed DDL executions in xCluster replication. {{}} * Enables faster table lock acquisition through shared memory in YugabyteDB. {{}} * Stores object lock requests in shared memory to enhance crash safety. {{}} * Enhances lock management by disabling fastpath during lock conflicts. {{}} * Adds ASH instrumentation to snapshots for better tracking of backup and snapshot bottlenecks. {{}} * Adds base structure for background compaction in vector index. {{}} * Allows async functionality in TSLocalLockManager lock calls for enhanced database operations. {{}} * Defers processing of records with commit times exceeding the apply safe time to the next batch. {{}} * Corrects spelling error in `DEPRICATED_pgschema_name` to `Deprecated_pgschema_name` safely. {{}} * Reduces wait time for deadlocked transactions to abort by timing out waiters after `FLAGS_refresh_waiter_timeout_ms`. {{}} * Adds a flag to control the use of YbHnsw for vector indexing, requiring a drop and recreate for changes. {{}} * Allows detection of deadlocks involving fast path transactions when object locking is enabled. {{}} * Refactors shared memory management for better session control between TServer and pggate. {{}} * Enables chunks picking for background compaction based on size ratio. {{}} * Enables conditional tracing of ASH events to conserve memory. {{}} * Allows exporting snapshots with tables undergoing DDL operations. {{}} * Reverts commit disabling outstanding transactions during DDL until table locks feature is fully enabled. {{}} * Changes the default value for the `ysql_allow_duplicating_repeatable_read_queries` flag to true. {{}} * Increases limits for concurrent replica removals and over-replicated tablets to speed up cluster operations. {{}} * Updates the Tablet Server UI page for better organization and readability. {{}} * Removes `-ftime-trace` from Clang builds to enhance compatibility with ccache. {{}} * Adds memory tracking to vector indexes for better resource management. {{}} * Enhances check_data_blocks command output and logging to include data block number, index key, and distinguish corruption. {{}} * Automatically adds ASH metadata to selected RPCs, maintaining a list of exceptions where metadata shouldn't be added. {{}} * Speeds up cluster load balancing by considering tablet sizes for parallelism. {{}} * Handles out-of-order messages to prevent lock leakage by cleaning up after specified `ignore_after_hybrid_time`. {{}},{{}} * Reduces risks by not updating `master_ysql_operation_lease_ttl_ms` flag unnecessarily. {{}} * Replaces `yb::ThreadPool` with `YBThreadPool` to enhance concurrent access and reduce latency by 5-8%. {{}} * Converts `xcluster_enable_ddl_replication` from a preview flag to an `kExternal` flag. {{}} * Enables `TRUNCATE TABLE` support in xCluster automatic mode with new flags and triggers. {{}} * Streamlines operations by removing unnecessary flag checks on the master for table locks. {{}} * Ensures xCluster DDL replication tables are included in backups. {{}} * Reduces latency of YSQL write statements and lock-grabbing reads in distributed transactions by enabling async writes. {{}} * Reduces unnecessary transaction conflict errors by auto-retrying status requests. {{}} * Removes unnecessary log line that occurs whenever a tablet is deleted. {{}} * Enhances on-disk size metrics to include snapshots, improving cluster balancer accuracy. {{}} * Adds metrics for tracking fastpath object lock acquires. {{}} * Turn on `enable_object_lock_fastpath` by default in Linux release builds, not affecting debug builds. {{}} * Allows table servers to attempt to release their YSQL lease during shutdown, enabling other servers to process DDLs and DMLs without delay. {{}} * Enables core dumps on FATAL errors with new flag `disable_core_dumps_on_fatal`. {{}} * Enables `enable_object_lock_fastpath` and `pg_client_use_shared_memory` in all Linux builds. {{}} * Adds hnswlib as an additional backend for hnsw vector index, enhancing search performance options. {{}} * Boosts search performance by skipping deletion checks on tables that only perform inserts. {{}} * Adds metadata and wait events to xCluster poller, enhancing visibility into bottlenecks. {{}} * Enables dependency on the transactional DDL flag for the object locking feature to prevent self-deadlocks. {{}} * Enables automatic selection of optimal distance function based on user's CPU capabilities, enhancing USearch's efficiency. {{}} * Enhances reliability by retrying exclusive lock requests during YSQL lease membership changes. {{}},{{}} * Allows execution of ANALYZE command on both primary and standby clusters independently. {{}} * Allows checking multiple replication infos and tablet numbers for creating multiple tables simultaneously. {{}} * Refactors boost::optional to std::optional for consistency and removes unused files, enhancing error handling in arclint. {{}} * Enables AVX implementation in HNSWlib for better vector index performance using advanced CPU capabilities. {{}} * Optimizes asan/tsan builds to use -O3 level and allows optional debug checks with new asan_release/tsan_release builds. {{}} * Allows parallel merging of vector index chunks using the insert priority thread pool to reduce compaction time. {{}} * Raises the minimum GCC version to GCC 12, compatible with all supported build platforms. {{}} * Implements custom DDL-based timeouts for DropTable and DropDatabase operations. {{}} * Splits client's FlushTables into two methods, CompactTables and FlushTables, for enhanced extensibility. {{}} * Allow vector indexes compaction with compact_table by using the ADD_VECTOR_INDEXES parameter. {{}} * Simplifies DocDB iteration by removing unnecessary split between `IntentAwareIteratorIf` and `DocRowwiseIteratorBase` for new feature implementation. {{}} * Allows toggling the colocated table tombstone cache optimization using the flag `FLAGS_enable_colocated_table_tombstone_cache`. {{}} * Adds CRC checksum to RPC responses to prevent data corruption. {{}} * Optimizes row scanning in `HybridScanChoices` by introducing `ScanTarget` class to eliminate the need for repeated key decoding. {{}} * Allows updating `remote_bootstrap_rate_limit_bytes_per_sec` flag in real-time for each file or session. {{}} * Adds vector index reverse mapping decoding support to the sst-dump tool. {{}} * Switch to clang built with PGO in llvm-installer version for faster C/C++ compile and link times, reducing overall build times by 9-11%. {{}} * Updates compaction logic to correctly handle and clean tombstoned reverse-mapping vector index keys. {{}} * Adds server-level metrics to track the number of transactions started as global, region-local, and tablespace-local. {{}} * Allows tablespace-local transactions to write to tables in any contained tablespace without global promotion. {{}} * Displays xCluster safe time on yb-master UI page for enhanced debugging. {{}} * Introduces two YSQL configuration parameters to control use of tablespace-local locality, offering workaround for suboptimal performance in certain cases. {{}} * Calculates region locality on the TServer side for improved region local transactions handling. {{}} * Allows reads and writes to proceed without waiting for a full quorum acknowledgment, reducing YSQL write and read latencies. {{}} * Introduces disk write statistics for vector compaction, which offers insights into IO across vector index libraries. {{}} * Configure RocksDB keys delta-encoding separately for YCQL and YSQL for faster read path and space efficiency. {{}} * Enables skip prefix locks by default for new installation clusters. {{}} * Enables vector index background compactions by default to control parallel execution and limit compactions per TServer. {{}} * Refactors code to address contention issues on `CatalogManager::mutex_` in larger clusters, enhancing stability and performance. {{}} * Enables dynamic sorting by columns in heap snapshot UI and reduces risk of database overload. {{}} * Adds BSON and BID libraries to cmake, making the DocumentDB extension part of the build process, except for aarch64 due to upstream restrictions. {{}} * Adds DocumentDB extension to non-aarch64/arm64 builds, with new flag `ysql_enable_documentdb` for protection. {{}} * Supports major YSQL upgrades with xCluster by relaxing checks, allowing soft delete and recreate of databases. {{}} * Adds a yb-admin command to check if nodes can be taken down without losing quorum. {{}} * Standardizes long-form flag names in documents to use double dashes for clarity. {{}} * Adds periodic cleanup for DDL replication tables to prevent unbounded growth. {{}} * Simplifies ObjectLockManagerImpl code for easier maintenance and future updates. {{}} * Ensures AuthOK messages are sent immediately to clients, simplifying future changes. {{}} * Allows users to specify SSL ciphers and minimum TLS version on webserver ports. {{}} * Renames "Network" wait_event_type to "RPCWait" for clarity. {{}} #### CDC * Eliminates usage of `pgschema_name` in `CreateTable` pipeline and introduces a new field `internal_table_type` to replace direct reading of PG Schema Name during table creation. {{}} * Adds a `yb_restart_time` column to `pg_replication_slots`. {{}} * Prevents data loss during restarts by not sending checkpoints if tablet safe time exceeds slot restart time. {{}} * Adds instrumentation for RPCs sent to CDC Service, and new wait events enabling detection of bottlenecks in CDC by ASH. {{}} * Displays replica identity map in `list_change_data_streams` output. {{}} * Enhances error propagation from `GetChanges` to clients for more transparency. {{}} * Updates descriptions for CDC retention flags and their dependencies, and clarifies validator error messages. {{}} #### yugabyted * Activates read committed isolation and cost-based optimization by default for newly started clusters. {{}} * Adds an environment variable to show accurate CPU details and corrects VCPU display in yugabyted-ui in Kubernetes deployments. {{}} * Upgrades yugabyted-ui TypeScript version to 5.0.4 for better package compatibility. {{}} * Enables `yb_extension` role to create access methods during extension setup. {{}} * Aligns the styling of assessment voyager page with the provided design without disrupting schema migration page operation. {{}} * Updates the voyager analysis page in yugabyted according to the design provided. {{}} ### Bug fixes #### YSQL * Allows preservation of read time history to prevent "Bad read time serial" error during COPY operations in middle-commit scenarios. {{}} * Allows prompt response to PostgreSQL interrupts, enhancing handling of statement timeouts and cancel requests. {{}} * Exempts walsender processes managed by the connection manager from YSQL backend checks. {{}} * Allows setting YSQL configuration parameters to a whitespace empty value without causing error. {{}} * Reverts a previous change that caused performance issues, ensuring timely execution of statements by honoring the YSQL configuration parameter `statement_timeout` during index scans with specific predicates. {{}} * Fixes errors and crashes when creating temporary tables with `ON COMMIT DROP`. {{}} * Resolves GCC 13 release build failures on Linux. {{}} * Allows sharing of perform operation serial number counter among multiple PostgreSQL processes to ensure unique serial numbers and better operation execution. {{}} * Allows users to preload `pg_enum` in `ysql_catalog_preload_additional_table_list`. {{}} * Prevents YSQL major upgrade failure caused by inconsistent namespace mapping during a failed upgrade attempt. {{}} * Allows yb-admin ysql_catalog_version command to return per-DB Catalog Version value for a provided database. {{}} * Adds missing primary keys and unique constraints to system catalogs, enabling them during initdb and YSQL upgrade. {{}} * Disables neg hit optimization for inherited cache when minimal preload is on. {{}} * Enhances upgrades for indexes with hash column groups to correctly handle aliases and metadata. {{}} * Allows group and others read permission on initdb log files by hardcoding the permission. {{}} * Ensures joins are only pruned when a Leading hint exists, avoiding errors. {{}} * Allows on-demand reading from non-prefetched tables by downgrading log level from `DFATAL` to `WARNING`, eliminating `Snapshot too old` and cache inconsistency issues. {{}} * Allows the use of PostgreSQL's snapshot management for foreign key triggers in YSQL, eliminating potential foreign key violations and enhancing data integrity. {{}} * Ensures `TimeZone` is not lowercased in connection manager for correct pgJDBC interpretation. {{}} * Keeps historical query diagnostics data persistent, even after a server restart or crash. {{}} * Allows placement of table replicas in any specified region or zone using `*` wildcard. {{}} * Reduces sequence-related errors when using `ysql_conn_mgr_sequence_support_mode=pooled_with_currval_lastval`. {{}} * Corrects issues with foreign keys referencing partitioned tables, preventing `TupleDesc reference leak` warnings and crashes during insert queries. {{}} * Corrects a queue ordering logic by using `std::lower_bound` to prevent TServer crashes. {{}} * Preserves column order during backup restore of inherited tables, matching DocDB and PG orders. {{}} * Fixes `ANALYZE` failures on wide tables by adjusting fetch size limits. {{}} * Ensures auto analyze runs after table rewrites like TRUNCATE. {{}} * Allows dumping of profiles and role mappings in `ysql_dumpall`. {{}} * Enhances session stickiness when acquiring session-scoped advisory locks. {{}} * Fixes DROP CASCADE to remove generated columns from DocDB. {{}} * Ensures consistency in secondary index scans during concurrent DELETE_INSERT operations. {{}} * Allows flushing or dropping of buffered operations before executing commands that affect the session state. {{}} * Resets user ID and security context between ANALYZE retries for stability. {{}} * Ensures DDL statements initiate DocDB transactions correctly to prevent errors. {{}} * Disables automatic retries for `COPY FROM/TO` commands. {{}} * Disables writes to role profile tables during YSQL upgrades to prevent errors. {{}} * Enables accurate tablespace dependency tracking for tables moved via `ALTER TABLE SET TABLESPACE`. {{}} * Avoids segmentation faults in ASH queries by initializing wait states to `kIdle` instead of `kUnused`. {{}} * Fixes a bug that caused yb-master to crash when executing the CREATE INDEX command outside of a transaction block with savepoint for DDL support enabled via `TEST_ysql_yb_enable_ddl_savepoint_support`. {{}} * Supports multiple analyze commits and concurrent DDL, ensuring low priority lock on pg_yb_catalog_version is retaken during subsequent transactions. {{}} * Prevents PostgreSQL crash by avoiding invalidation messages during catalog refresh when prefetcher starts. {{}} * Forces loading of index expressions during index creation to prevent missed updates and potential inconsistencies. {{}} * Fixes the issue of transaction self-abort with rollback to savepoint, allowing users to rollback DDL operations without facing transaction expired/conflict error. {{}} * Disables query layer retry of ANALYZE command to prevent potential crashes caused by dirty states. {{}} * Eliminates an issue causing stuck rollback operations to sub-transactions with alter table. {{}} * Automatically sets default values for dependent flags when the YSQL Cost-Based Optimizer (CBO) is enabled or disabled. {{}} * Ensures successful backup restore of colocated databases with unique constraints by correctly preserving implicit tablegroup. {{}} * Disallows disabling DDL atomicity with YSQL configuration parameters if transactional DDL is enabled, preventing potential issues. {{}},{{}} * Adds multi-snapshot execution mode to `yb_index_check` operation, reducing risk of `Snapshot too old` error on larger indexes. {{}} * Allows large values to be inserted into temporary tables by enabling toast tables for temporary relations. {{}} * Prevents errors by detoasting values before insertion into DocDB tables. {{}} * Enhances fast-path transaction accuracy by adjusting read time settings. {{}} * Re-enables password redaction for specific SQL statements in YugabyteDB. {{}} * Restores the call to `ScheduleCheckObjectIdAllocators` inadvertently removed. {{}} * Fixes a use-after-free bug in ysql_dump by copying tablegroup_name. {{}} * Allows `yb_binary_restore` to be set by `ybdbadmin` for vector extension creation. {{}} * Enables `postgres_fdw` to use `ybctid` for identifying tuples, ensuring compatibility and functionality. {{}} * Ensures `ybctid` is correctly populated in RETURNING clauses for DML queries. {{