What follows are the release notes for the YugabyteDB 2025.1 release series. Content will be added as new notable features and changes are available in the patch releases of the YugabyteDB 2025.1 release series. For an RSS feed of all release series, point your feed reader to the [RSS feed for releases](../index.xml). ## v2025.1.3.2 - February 26, 2026 {#v2025.1.3.2} **Build:** `2025.1.3.2-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.3.2/yugabytedb-2025.1.3.2-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.3.2/yugabytedb-anywhere-2025.1.3.2-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.3.2-b1 ``` This is a YugabyteDB Anywhere-only release, with no changes to YugabyteDB. ## v2025.1.3.1 - February 5, 2026 {#v2025.1.3.1} **Build:** `2025.1.3.1-b2` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.3.1/yugabytedb-2025.1.3.1-b2-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.3.1/yugabytedb-anywhere-2025.1.3.1-b2-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.3.1-b2 ``` ### Bug fixes #### YSQL * Ensures consistent index updates during `INSERT ... ON CONFLICT` operations. {{}} #### DocDB * Fixes tablet split validation to handle 0x0000 as an empty key for hash partitions. {{}} ## v2025.1.3.0 - January 16, 2026 {#v2025.1.3.0} **Build:** `2025.1.3.0-b75` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.3.0/yugabytedb-2025.1.3.0-b75-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.3.0/yugabytedb-anywhere-2025.1.3.0-b75-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.3.0-b75 ``` ### Improvements #### YSQL * Introduced a GUC to allow users to revert to the previous foreign key triggers snapshot mode, with caution advised. {{}} * Query Diagnostics upgrades to Early Access status in version 2025.1 {{}} * Refined type conversions in index backfill code for better consistency and safety. {{}} * Optimized the PostgreSQL build process by removing the redundant and time-consuming install_wrapper.py. {{}} * Deprecated the flag `ysql_conn_mgr_max_phy_conn_percent` and introduced new flag `ysql_conn_mgr_reserve_internal_conns` for reserving connections for internal operations. {{}} #### DocDB * Reworked the load balancer to not hold `CatalogManager::mutex_` for each placement run, thus improving efficiency. {{}} * Introduced `InterprocessSharedMemoryObject` and `InterprocessMappedRegion` to wrap `boost::interprocess` calls, converting exceptions to `Status` returns. {{}} * Refactored mutex acquisitions in larger clusters to mitigate contention issues. {{}} * 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. {{}} * 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. {{}} * Re-enables LogReader memory limit in xCluster following resolution of TryConsume bug. {{}} * Added compiler errors to Odyssey build for improved compile-time checking. {{}} #### CDC * Added runtime flag to control CDC with Savepoints and Rollback feature, and introduced tests for rollback and savepoint behavior. {{}} * 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. {{}} * Introduced shared data feature for YSQL pggate in parallel leader and worker processes to ensure each operation has a unique serial number for better execution order control. {{}} * 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 `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 flag `pggate_rpc_timeout_secs`. {{}} * Fixed issue where unique index data was missing for colocated databases after restore, now preserving implicit tablegroup oid. {{}} * 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. {{}} * Fixed a bug that caused crashes when arrays of more than two dimensions are passed to a scalar array operation. {{}} * Fixes are introduced to address intra-query memory leaks during long-running write queries, reducing transient memory spikes and improving memory allocation. {{}},{{}} * Fixed an issue with prepared statements on temporary tables when using extended query protocol. {{}} * Fixed a metadata correctness bug that caused errors when using minimal preloading with negative caching. {{}} * 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. {{}} * Fixed read restart error occurring during concurrent execution of CREATE TEMP TABLE. {{}} * Refactored index backfill code in YSQL for improved readability and efficiency by standardizing field names and optimizing row reading process. {{}} * Introduces a new flag `ysql_yb_enable_update_reltuples_after_create_index` to update `reltuples` for base table and index after CREATE INDEX, aligning with PostgreSQL behavior. {{}} * Fixed a missing build dependency issue in the yb_pgwrapper library that caused a failure when running build with clean-postgres. {{}} * Adds flag for GUC `yb_ignore_bool_cond_for_legacy_estimate`, allowing setting via flag before upgrading from 2.20. {{}} * 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. {{}} * Fixed an issue where connection manager could crash during authentication due to a double free error. {{}} * Fixed an issue where bind packets were not forwarded to the backend in certain cases involving unnamed prepared statements. {{}} #### DocDB * Prevents sending of `YBParsePrepareErrorResponse` packet for unnamed prepared statements. {{}} * Prevents TServer process crash and unusable PostgreSQL connections by correctly handling thread creation failure and falling back to RPC mechanism. {{}} * Now only live tablet servers are contacted when updating transaction version, enabling deletion of transaction tables even if a tablet server is down. {{}} * Fixed deadlock in MasterSnapshotCoordinator by modifying PopulateDeleteRetainerInfoForTableDrop to pass `table_info` to IsTabletCoveredBySnapshot. {{}} * Resolved backup restore failures by changing the `enable_export_snapshot_using_relfilenode` autoflag from `kLocalVolatile` to `kExternal`, protecting `format_version` field changes in `SnapshotInfoPB`. {{}} * Switched from using SIGQUIT to SIGINT to stop the PostgreSQL postmaster, preventing core dump generation at TServer startup. {{}} * Introduces `min_replay_txn_first_write_ht` to address transaction data loss that occurred due to incorrect filtering of transactions on bootstrap. {{}} * Fixes bug where ALTER TABLE statements would not roll back in case of master crash during the ALTER TABLE DDL operation. {{}} * 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. {{}} * Resolved issues related to Read Committed transactions encountering `kDeadlock` errors, especially in cases involving advisory locks and DDL transactions. {{}} * Implemented root memtracker adjustment to limit deviation from TCMalloc stats, avoiding overestimation and false triggering of memory limits. {{}} * Switched from using SIGKILL to SIGQUIT and SIGINT for stopping postmaster process during lease loss and TServer shutdown respectively. {{}} * Disables intent filtering for bootstrap due to transaction filtering issues with use_bootstrap_intent_ht_filter set to true. {{}} * Fixes a regression that allowed restoring to a time earlier than the maximum retention window, potentially causing database instability. {{}} * 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. {{}} #### CDC * Fixed issue in `PeerMessageQueue::ReadReplicatedMessagesForConsistentCDC` where WAL Ops were missed due to bugs in record reading and handling of approaching deadlines. {{}} * Optimizes the WalSndWakeup function by returning early to prevent unnecessary spin lock acquisitions and core dump occurrences. {{}} * Adds support to filter aborted subtransactions (rolled-back savepoints) in CDC streaming, making it consistent with the apply path. {{}} * Fixed issue where child tablets wrongly inherited parent tablet's checkpoint after a tablet split, causing CDC stream failures. {{}} * Fixed error in UpdatePeersAndMetrics for Sys Catalog tablet, improving handling of `pg_publication_rel` and `pg_class` tables. {{}} ## v2025.1.2.2 - December 17, 2025 {#v2025.1.2.2} **Build:** `2025.1.2.2-b5` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.2.2/yugabytedb-2025.1.2.2-b5-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.2.2/yugabytedb-anywhere-2025.1.2.2-b5-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.2.2-b5 ``` This is a YugabyteDB Anywhere-only release, with no significant changes to YugabyteDB. ## v2025.1.2.1 - December 2, 2025 {#v2025.1.2.1} **Build:** `2025.1.2.1-b4` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.2.1/yugabytedb-2025.1.2.1-b4-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.2.1/yugabytedb-anywhere-2025.1.2.1-b4-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.2.1-b4 ``` This is a YugabyteDB Anywhere-only release, with no significant changes to YugabyteDB. ## v2025.1.2.0 - November 20, 2025 {#v2025.1.2.0} **Build:** `2025.1.2.0-b110` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.2.0/yugabytedb-2025.1.2.0-b110-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.2.0/yugabytedb-anywhere-2025.1.2.0-b110-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.2.0-b110 ``` ### New features * [CDC data now retained for 24 hours by default](/v2025.1/additional-features/change-data-capture/using-logical-replication/advanced-configuration/#retention-of-resources) in case the CDC client/consumer is offline. {{}} * Improved [YSQL Connection Manager](/v2025.1/explore/going-beyond-sql/connection-mgr-ysql/) performance. Reduced the cost of binding logical to physical connections to improve performance and lower application-level latencies, specifically by optimizing the GUC workflow. {{}} ### Improvements #### YSQL * Allows specifying colocation option for parent partition tables and splits parent partition tables into a single tablet. {{}},{{}} * Ensures YSQL index backfill operations resume seamlessly after a master leader failover. {{}} * Adds extra locality info from PostgreSQL to TServer for better transaction categorization and performance. {{}} * Enhances row boundary settings for hash-partitioned tables using encoded DocKeys. {{}} * Enables integration of YSQL with PostgreSQL snapshot management for Repeatable Read isolation level. {{}} * Add a new counter to track new connections performing catalog preloads, aiding in debugging. {{}} * Sets stricter copyright enforcement for C++ files on master but reduces rule severity on backport branches. {{}} * Adds the ability to display commit stats with the EXPLAIN command, helping users understand latency in multi-region workloads. {{}} * Avoids unnecessary memory spikes and ensures freshest catalog data for relationship cache initialization. {{}} * Enhances logging for tracking unexpected full catalog refreshes in YSQL. {{}} * Streamlines request pagination in scans for consistent behavior across all directions. {{}} * Adds new YSQL configuration parameter `yb_enable_cbo=legacy_ignore_stats_bnl_mode`. {{}} * Set YSQL configuration parameter `yb_read_after_commit_visibility` to `relaxed` to avoid `restart read required` errors during `yb_index_check`. {{}} * Expands EXPLAIN (ANALYZE, DIST) output to include transaction type, enabling a more formal way to deduce transaction type. {{}} * Increases timeout for TServer catalog version wait to 30 seconds, reducing connection time outs. {{}} * 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. {{}} * Displays storage flush reasons under debug logs for better query performance analysis. {{}} * Reduces peak memory usage in `yb_active_session_history` by filtering out rows more quickly. {{}} * Enables viewing tcmalloc memory statistics for the connection manager. {{}} * Enhances CM decision-making by always using a custom ParameterStatus packet. {{}} #### DocDB * Adjusts the `wal_size` metric to include the size of the current active, writable segment, ensuring accurate reflection of on-disk size. {{}} * Adds logging to detect and inform if scheduled tasks in the reactor run slower than expected. {{}} * Allows transaction status tablets to be grouped by tablespace for future categorization of transactions. {{}} * 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. {{}},{{}} * Renames TabletHarness to TabletTestHarness for clearer test code identification. {{}} * Enables the use of CREATE TABLE AS SELECT (CTAS) in an xCluster replication setup. {{}} * Adds new wait events for ASH instrumentation to identify bottlenecks during bootstrap. {{}} * Converts `xcluster_enable_ddl_replication` from a preview flag to an `kExternal` flag. {{}} * Adds ASH instrumentation to snapshots for better tracking of backup and snapshot bottlenecks. {{}} * 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. {{}} * Adds server-level metrics to track the number of transactions started as global, region-local, and tablespace-local. {{}} * 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. {{}} * Reduces latency of YSQL write statements and lock-grabbing reads in distributed transactions by enabling asynchronous writes. {{}} * Allows reads and writes to proceed without waiting for a full quorum acknowledgment, reducing YSQL write and read latencies. {{}} * Adds upgrade check to detect and require removal of invalid indexes. {{}} * Enables skipping network compression for SST files during remote bootstrap, improving latencies and scale-out times. {{}} * Supports multi-statement DDLs and pg_partman, allowing you to capture exact DDL sub-queries and replicate them on the target cluster. {{}} #### CDC * Sets retention barriers on the sys catalog tablet during stream creation as a RAFT operation, enhancing data consistency. {{}} * Promotes the flag `ysql_yb_enable_implicit_dynamic_tables_logical_replication` from a test to preview flag. {{}} * Reverts a commit due to a misunderstanding about the effects of failures when writing to the CDC state table. {{}} * Displays replica identity map in `list_change_data_streams` output. {{}} * Enhances error propagation from `GetChanges` to clients for more transparency. {{}} ### Bug fixes #### YSQL * Allows preservation of read time history to prevent "Bad read time serial" error during COPY operations in middle-commit scenarios. {{}} * 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. {{}} * Allows group and others read permission on initdb log files by hard coding the permission. {{}} * Ensures `TimeZone` is not lowercased in connection manager for correct pgJDBC interpretation. {{}} * Allows the use of PostgreSQL's snapshot management for foreign key triggers in YSQL, eliminating potential foreign key violations and enhancing data integrity. {{}} * Disables writes to role profile tables during YSQL upgrades to prevent errors. {{}} * Forces loading of index expressions during index creation to prevent missed updates and potential inconsistencies. {{}} * Reduces RPCs by using Index Only Scan for `INSERT ...ON CONFLICT ...DO NOTHING` statements. {{}} * Fixes crashes when locking rows in temporary tables by setting the correct transaction state. {{}} * Reduces unnecessary catalog version increments for renames on temporary relations. {{}} * Adds multi-snapshot execution mode to `yb_index_check` operation, reducing risk of `Snapshot too old` error on larger indexes. {{}} * Deprecates the YSQL configuration parameter `yb_make_next_ddl_statement_nonincrementing` to enable incremental catalog cache refresh by default. {{}} * Restores distinct error messages for `kAbort` and `kConflict` errors for clearer troubleshooting. {{}} * Fixes an error where a join condition was incorrectly pushed down in a batched nested loop, preventing crashes during planning. {{}} * Enables execution of DELETE and (re-)INSERT operations in a single flush for indexed JSONB columns, making updates less expensive. {{}} * Adds a preflight check to fail upgrades if user-defined roles with the `yb_` prefix exist, except `yb_superuser`. {{}} * Enhances error message clarity when altering the primary key index owner. {{}} * Corrects index-only scans in unbatched INSERT...ON CONFLICT...DO NOTHING queries for multi-column indexes. {{}} #### DocDB * Solves the reversed condition in the rpc_inbound_calls_failed metric, offering more metric information. {{}} * Ensures tablet split handling on the consumer side does not cause incorrect mappings due to race conditions. {{}} * Changes prevent unnecessary node crashes due to network issues during remote bootstrapping process cleanup. {{}} * Allows removal of associated intentsdb keys during tablet startup to prevent potential pileup and slower queries. {{}} * Add a test for cloning to a time before dropping a materialized view and a column in the base table. {{}} * Prevents silent data loss by failing the clone when a table is altering instead of cloning without data. {{}} * Disables TryConsume usage by LogReader to prevent user operations from being incorrectly blocked due to a bug. {{}} * Allows namespace_id to be correctly copied in TableInfo constructors to prevent empty return values. {{}} * Enables re-acquisition of object locks during statement retries in extended query mode execution. {{}} * Prevents fatal errors in xCluster by ensuring all schema versions are present during replication. {{}} * Fixes exclusive lock intents acquisition before shared memory setup. {{}} * Object locks now respect `yb_locks_min_txn_age` and `yb_locks_max_transactions` settings. {{}} * Fixes an issue where aborted transactions could get stuck with object locks. {{}} * Adds CRC checksum to RPC calls to detect data corruption. {{}} * Adds a memory tracker to monitor temporary memory used when reading WALs, preventing TServer crashes. {{}} * Allows deletion of hidden tablets during point-in-time restores that are no longer in use. {{}} * Reduces master_rpc_timeout_ms to 1.5s to lessen outages by quickly detecting dead/unavailable master nodes. {{}} * Reduces `Unable to find schema name for YSQL table` errors and optimizes the retrieval of YSQL Table Oid. {{}},{{}} * Adjusts active log segment size tracking for accurate `wal_size` metric when reusing existing segments. {{}} * Eliminates stale hashmap entries on parse errors, enhancing protocol-level prepared statement handling. {{}} Alleviate restore failures by adjusting the 'enable_export_snapshot_using_relfilenode' autoflag from 'kLocalVolatile' to 'kExternal' and introducing backward compatibility for the 'yb_ignore_relfilenode_ids' YSQL configuration parameter. {{}} #### CDC * Ensures only tables in a publication are checked for `CHANGE` replica identity. {{}} * Introduces the `yb_ignore_read_time_in_walsender` parameter for logical replication continuity during upgrades. {{}} * Handles error propagation from CDC to client for missing footer in segments. {{}} * Allows large transactions for unqualified tables to stream correctly, preventing the virtual WAL from getting stuck. {{}} * Fixes CDC issue with virtual WAL restart after a DDL, preventing record decoding failure. {{}} * Stops applying the LogReader memory limit to CDC, a setting intended only for xCluster. {{}} * Adds "Log index cache entry for op index not found" error to retryable errors in cdcsdk_virtual_wal. {{}} * Reduces the frequency of log spam due to missing tablet warnings by changing logging parameters. {{}} ## v2025.1.1.2 - October 20, 2025 {#v2025.1.1.2} **Build:** `2025.1.1.2-b3` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.1.2/yugabytedb-2025.1.1.2-b3-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.1.2/yugabytedb-anywhere-2025.1.1.2-b3-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.1.2-b3 ``` ### Improvements #### YSQL * Allows specifying colocation option for parent partition tables and splits parent partition tables into a single tablet. {{}},{{}} * Adds extra locality info from PostgreSQL to TServer for better transaction categorization and performance. {{}} #### DocDB * Allows transaction status tablets to be grouped by tablespace for future categorization of transactions. {{}} * 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. {{}} ### Bug fix #### YSQL * Eliminates stale hashmap entries on parse errors, enhancing protocol-level prepared statement handling. {{}} ## v2025.1.1.1 - October 3, 2025 {#v2025.1.1.1} **Build:** `2025.1.1.1-b1` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.1.1/yugabytedb-2025.1.1.1-b1-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.1.1/yugabytedb-anywhere-2025.1.1.1-b1-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.1.1-b1 ``` ### Highlights We're excited to announce the key features and enhancements in the 2025.1.1.1 release, designed to improve performance, usability, and management of your database environments. **Table-level locking for concurrent DDL and DML** {{}} Added [Table-level locks](/v2025.1/explore/transactions/explicit-locking/#table-level-locks) to support concurrent DDL and DML operations, improving workload concurrency and reducing conflicts during schema changes. **YugabyteDB CDC Connector on Confluent Hub** {{}} The YugabyteDB CDC Connector is now available directly on Confluent Hub, making it easier to integrate YugabyteDB into event-driven architectures. For more information on CDC, refer to [Change data capture (CDC)](/v2025.1/additional-features/change-data-capture/). **Truncate table support in xCluster replication** {{}} Enables TRUNCATE operations to be safely replicated in xCluster environments, ensuring consistency across distributed clusters. For more information, refer to [xCluster replication](/v2025.1/architecture/docdb-replication/async-replication/). ### New features * Added support for SCRAM-based password authentication in [Connection manager](/v2025.1/additional-features/connection-manager-ysql/ycm-setup/#authentication-methods), enhancing security beyond the previously supported MD5 method. {{}} * [Query diagnostics](/v2025.1/launch-and-manage/monitor-and-alert/query-tuning/query-diagnostics/). You can use a new YSQL function `yb_query_diagnostics`, to create a diagnostics bundle for a normalised YSQL query for a time range to speed up troubleshooting. The bundle contains critical data like the EXPLAIN PLAN, bind variables, pg_statement_stats, schema details, and Active Session History. {{}} ### Change log
View the detailed changelog ### Improvements #### YSQL * Resets the DDL state for read-only transactions to avoid state persistence issues. {{}},{{}} * Enables configuration of transactional DDL blocks via the `yb_ddl_transaction_block_enabled` flag. {{}},{{}} * Supports executing DDL statements in READ COMMITTED isolation with options to disable retries. {{}} * Reduces the frequency of auto-analyze on small, frequently-updated tables. {{}} * Reduces unexpected full catalog cache refreshes in new PG backends. {{}} * Enhances logging for tracking unexpected full catalog refreshes in YSQL. {{}} * Enhances logging for troubleshooting unexpected full catalog refreshes by adding `CatalogInvalMessagesDataDebugString`. {{}} * Captures and returns per-RPC metrics for write operations. {{}} * Simplifies code management by separating cancelable and non-cancelable scopes. {{}} * Allows `upgrade_ysql` to exit early if YSQL is not enabled. {{}} * Displays write RPC metrics in `EXPLAIN (ANALYZE, DIST, DEBUG)` output. {{}} * Removes the `YB_BITMAP_DISCOURAGE_MODIFIER` to better reflect actual bitmap scan costs. {{}} * Adds `GUC_EXPLAIN` flag to YB-specific GUC parameters for enhanced EXPLAIN output. {{}} * 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`. {{}} * Simplifies conditional cleanup actions with `MakeOptionalScopeExit` function. {{}} * Introduces the `yb_fk_references_cache_limit` parameter to cap FK references cache entries at 65535. {{}} * Simplifies code for `Perfrom` requests, enhancing readability and usability. {{}} * Enables sending buffered write and multiple read operations in a single `Perform` RPC for YSQL. {{}} * Removes the beta label for various Foreign Data Wrapper commands in YSQL. {{}} * Displays transaction type in EXPLAIN (ANALYZE, DEBUG) output. {{}} * Ensures all `COPY FROM` commands in a transaction block use one transaction unit. {{}} * Enables sending buffered write operations and multiple read operations in a single RPC for optimized performance. {{}} * Includes transaction isolation level in serialization error messages. {{}} * Enables bounded staleness for PostgreSQL authentication backend cache using `pg_cache_response_trust_auth_lifetime_limit_ms`. {{}} * Allows dynamic updates to `ysql_hba_conf_csv` without server restarts. {{}} * Reduces master RPCs for PG auth backends by using TServer cache. {{}} * Disables Memoize under BNL to reduce CPU overhead without sacrificing performance. {{}} * Ensures proper error handling for unsupported LISTEN commands in connection manager mode. {{}},{{}} * Adds a flag `ysql_enable_scram_channel_binding` to enable SCRAM with channel binding. {{}} * Enables `yb_extension` role to create access methods during extension setup. {{}} * Increases default YSQL lease TTL to 5 minutes to minimize cluster disruptions. {{}} * Switches YSQL object lock calls to use shared memory, reducing overhead to 5-15%. {{}} #### DocDB * Ensures only voter peers are considered for leadership during a leader stepdown. {{}} * Fixes overflow in `FormatBytesAsStr` to prevent large memory allocations. {{}} * Ensures reliable xCluster history cutoff by backfilling `namespace_id` when necessary. {{}} * Refactors shared memory management for better session control between TServer and pggate. {{}} * Allows exporting snapshots with tables undergoing DDL operations. {{}} * Reduces risks by not updating `master_ysql_operation_lease_ttl_ms` flag unnecessarily. {{}} * Ensures xCluster DDL replication tables are included in backups. {{}} * Enables faster table lock acquisition through shared memory in YugabyteDB. {{}} * 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. {{}} * Stores object lock requests in shared memory to enhance crash safety. {{}} * Handles out of order table lock messages to prevent lock leakage. {{}},{{}},{{}} * Enhances lock management by disabling fastpath during lock conflicts. {{}} * 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. {{}} * Allows executing temporary table and materialized view DDLs on automatic mode xCluster targets without special configuration. {{}} * Increases limits for concurrent replica removals and over-replicated tablets to speed up cluster operations. {{}} * Reduces unnecessary transaction conflict errors by auto-retrying status requests. {{}} * Boosts search performance by skipping deletion checks on tables that only perform inserts. {{}} * Enhances on-disk size metrics to include snapshots, improving cluster balancer accuracy. {{}} * Adds metrics for tracking fastpath object lock acquires. {{}} * Speeds up cluster load balancing by considering tablet sizes for parallelism. {{}} * Enhances reliability by retrying exclusive lock requests during YSQL lease membership changes. {{}},{{}} * Applies a warning rather than an error for `boost::optional` lint rule in code reviews. {{}} * Adds periodic cleanup for DDL replication tables to prevent unbounded growth. {{}} * Allows admin users to create and alter publications for all tables, not just superusers. {{}} * Generates warnings instead of errors when setting `yb_disable_auto_analyze` via non-standard methods. {{}} * Adds an empty migration script to ensure smooth upgrades from version 2024.2. {{}} * Ensures AuthOK messages are sent immediately to clients, simplifying future changes. {{}} * Allows users to specify SSL ciphers and minimum TLS version on webserver ports. {{}} * Adds upgrade check to detect and require removal of invalid indexes. {{}} #### CDC * Enhances the `pg_stat_replication_slot` view with accurate and updated replication statistics. {{}} * Adds a `yb_restart_time` column to `pg_replication_slots`. {{}} * Enables CDC service on master to support dynamic table additions in logical replication. {{}} * Tracks changes in publications and new tables via virtual WAL polling. {{}} ### Bug fixes #### YSQL * Exempts walsender processes managed by the connection manager from YSQL backend checks. {{}} * Fixes errors and crashes when creating temporary tables with `ON COMMIT DROP`. {{}} * Resolves GCC 13 release build failures on Linux. {{}} * Fixes upgrade failures for indexes with hash column groups to correctly handle aliases and metadata. {{}} * Switches to reading from the latest catalog during YSQL GUC processing to prevent "Snapshot too old" errors. {{}} * Ensures `TimeZone` is not lowercased in connection manager for correct pgJDBC interpretation. {{}} * Allows dumping of profiles and role mappings in `ysql_dumpall`. {{}} * Ensures auto analyze runs after table rewrites like TRUNCATE. {{}} * Reduces sequence-related errors when using `ysql_conn_mgr_sequence_support_mode=pooled_with_currval_lastval`. {{}} * Enhances session stickiness when acquiring session-scoped advisory locks. {{}} * Ensures consistency in secondary index scans during concurrent DELETE_INSERT operations. {{}} * Resets user ID and security context between ANALYZE retries for stability. {{}} * Ensures DDL statements initiate DocDB transactions correctly to prevent errors. {{}} * Fixes DROP CASCADE to remove generated columns from DocDB. {{}} * Disables automatic retries for `COPY FROM/TO` commands. {{}} * 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`. {{}} * Ensures accurate EXPLAIN output for forward scans with aggregate pushdown. {{}} * Enables TOAST table creation for temporary tables in `REFRESH MATERIALIZED VIEW CONCURRENTLY`. {{}} * Disables `yb_force_early_ddl_serialization` by default to avoid conflict errors. {{}} * Fixes DROP COLUMN handling for tables with child partitions requiring rewrite. {{}} * Fixes stale reads in `pg_yb_invalidation_messages` to prevent full catalog refreshes. {{}} * Ensures PostgreSQL shuts down before deleting upgrade data to prevent crashes. {{}} * Assigns accurate query IDs to RPCs executed outside of executor hooks. {{}} * Fixes crash by initializing CacheMemoryContext during backend startup. {{}} * Reduces unnecessary full catalog cache refreshes in certain scenarios. {{}} * Enables `postgres_fdw` to use `ybctid` for identifying tuples, ensuring compatibility and functionality. {{}} * Corrects EXPLAIN output estimates for Bitmap Index Scans, enhancing accuracy in performance analysis. {{}} * Supports accurate cost estimates for hypothetical indexes in both old and new models. {{}},{{}} * Prevents server crashes when multiple backend processes terminate while one holds a spinlock. {{}} * Fixes crash when using planner hints with hypothetical indexes. {{}} * Prevents crashes on transaction rollback with `ALTER TABLE` when transactional DDL is enabled. {{}},{{}},{{}} * Adds pgaudit 1.7.1 to enhance audit accuracy and resolve specific bugs. {{}} * Ensures unique event codes in `yb_wait_event_desc` to improve data analysis accuracy. {{}} * Separates commands in database upgrades to prevent read restart errors. {{}} * Ensures accurate catalog read counts for the first query in a session. {{}} * Enables `yb_db_admin` roles to set PL speculative execution parameters. {{}} * Fixes a compilation issue by converting an assert to an error. {{}} * Reverts recent changes to handle postmaster PANIC, improving stability during error scenarios. {{}} * Enhances fast-path transaction accuracy by adjusting read time settings. {{}} * Ensures the correct renew strategy for `IsRenewRequired` works as expected. {{}} * Ensures consistent query IDs for plan hints across settings and uses. {{}} * Ensures `yb_enable_cbo` correctly activates when legacy YSQL configuration parameters are ON. {{}} * Adds options to enable pre-2024.1 BNL cost behavior in non-CBO mode. {{}} * Enables `dump_role_checks` flag for new role-related statements in `ysql_dump` and `ysql_dumpall`. {{}} * Enables `dump_role_checks` in `ysql_dumpall` for role-related statements after creating profiles. {{}} * Deletes leftover invalidation messages when dropping a database. {{}} * Ensures consistent row filtering and paging in `PgsqlVectorFilter`. {{}} * Fixes deletion of leftover invalidation messages when databases are dropped. {{}} * Reduces unnecessary catalog version increments for renames on temporary relations. {{}} * Prevents crashes by holding route locks until the server closes in multi-route pooling. {{}} * Prevents cascading timeouts during authentication lags in the connection manager. {{}} * Enhances stability for YSQL connection manager during COPY operations from Go drivers. {{}} * Fixes a memory leak by using condition variables for signal handling in the connection manager. {{}} * Prevents indefinite stalls in multi-route pooling by ensuring signals are broadcast across all routes. {{}} * Fixes crashes during `ysqlsh` connections with empty passwords under load. {{}} * Enhances visibility of `ALTER ROLE ... SET` configurations across multiple databases. {{}} * Enables defining the maximum percentage of total YSQL connections for the connection manager. {{}} * Fixes authentication errors during consecutive cluster connections. {{}} #### DocDB * Prevents incorrect query results due to invalid seek keys in internal iterator operations. {{}} * Eliminates duplicate MasterService metrics for improved monitoring clarity. {{}} * Fixes unnecessary error logs during transaction loading with CDC enabled. {{}} * Prevents data loss during early compaction of replicated colocated tables. {{}} * Prevents thread metric data from disappearing over time. {{}} * Enhances Kubernetes compatibility by using RPC bind address as hostname in masters. {{}} * Enhances the stability of document reads by validating key prefixes before processing. {{}} * Ensures tablet server limits in the UI exclude dead or blacklisted nodes, providing accurate data metrics. {{}} * Prevents potential deadlocks in Raft operations by managing flusher state effectively. {{}} * Allows SST files with specific row or column TTLs to remain candidates for compaction. {{}} * Increases reliability of database cloning after a `DROP TABLE` operation. {{}} * Ensures better handling of schema versions during rapid DDL changes in xCluster replication. {{}},{{}} * Ensures correct order of setting `pg_hint_plan.enable_hint_table` and `compute_query_id` to prevent errors. {{}} * Prevents TServer crashes during concurrent vector index and read requests. {{}} * Prevents reuse of `docdb` transactions post-abort to avoid state conflicts in locks. {{}} * Reduces memory usage by optimizing `pg_locks` with specific iterator settings and intent limits. {{}} * Ensures safety by updating TabletPeer::GetNamespaceId to use `shared_tablet_safe`. {{}} * Resolves deadlock during TSHeartbeat by adjusting lock scope. {{}} * Eliminates potential deadlocks in thread pool by fixing a race condition. {{}} * Stops re-creating the xCluster DDL replication extension on the target. {{}} * Ensures OID counters in cloned or restored databases avoid conflicts after table drops. {{}} * Ensures OID counters advance adequately to avoid future table creation collisions. {{}} * Resolves PITR restore deadlocks by fixing lock inversion issues. {{}} * Ensures all fastpath object locks appear in `pg_locks` output. {{}} * Disables catalog version check for ReleaseObjectLocks API to prevent TServer crashes. {{}} * Eliminates redundant `rocksdb_block_cache_bytes_read` metrics to reduce noise and overhead. {{}} * Increases YSQL DDL RPC timeout to 180s and introduces configurable `ysql_ddl_rpc_timeout_sec` flag. {{}} * Prevents fatal errors in xCluster by ensuring all schema versions are present during replication. {{}} * Fixes exclusive lock intents acquisition before shared memory setup. {{}} * Eliminates undefined behavior by correcting the use of moved variables in `pg_client_session.cc`. {{}} * Allows skipping object locking during `initdb` to prevent failures. {{}} * Ensures TServer handles lock releases correctly after bootstrapping. {{}} * Prevents master crashes during index backfill by handling empty indexes correctly. {{}} * Adds a wait event for transactions with SERIALIZABLE READ ONLY DEFERRABLE. {{}} * Fixes placement logic to support wildcards in cloud info for tablet selection. {{}} * Ensures xCluster metrics display correct table IDs and namespaces for better monitoring accuracy. {{}} * Disables object locking when `ysql_enable_db_catalog_version_mode` is false. {{}} * Ensures consistent backup by exporting only committed DocDB tables at snapshot hybrid time. {{}},{{}} * Fail restore for unmatched DocDB tables during import_snapshot phase. {{}} * Fixes a bug to ensure correct data storage in PostgreSQL table cache requests. {{}} * Disables unnecessary logging when `FLAGS_txn_slow_op_threshold_ms` is set to 0. {{}} * Prevents deadlocks by setting status tablet ID for shared memory lock requests. {{}} * Eliminates DFATAL error for unregistered lock owners handling exclusive locks. {{}} * Ensures `TSLocalLockManager` is only created when both `enable_ysql` and `enable_object_locking_for_table_locks` are enabled. {{}} * Enables `ALTER DEFAULT PRIVILEGES` commands in xCluster automatic mode. {{}} * Defers transaction priority assignment to the first read/write operation. {{}} * Enhances metrics to better estimate cluster balancing times and validate the accuracy of the balancing algorithm. {{}} * Restores deletion of table info objects to prevent memory overload. {{}} * Stops xCluster polling when excessive DDL errors occur, preventing retries beyond limits. {{}} * Fixes issues with aborted transactions during promotions preventing stuck operations. {{}} * Ensures master metadata snapshots are consistent with `snapshot_hybrid_time` for accurate backups. {{}} * Restores previous deadlock detection by retrying lock requests from the host TServer. {{}} * Enforces TLS v1.2 for secure webserver connections. {{}} * Ensures cloning databases functions correctly with table locks enabled. {{}} * Preserves cluster balancer metrics correctly across all placements including read replicas. {{}} * Prevents table deletion during snapshot creation by implementing namespace anchoring. {{}} * Increases data metric's capacity to handle over 4 GB for balancing. {{}} * Fixes an issue where aborted transactions could get stuck with object locks. {{}} * Corrects xCluster status display for sequence data streams. {{}} * Disables pg_cron jobs on xCluster target by default, adjustable with `cron.yb_enable_on_xcluster_target`. {{}} * Prevents crashes by ensuring thread-safe rule de-referencing during route cleanup. {{}} * Reduces segmentation faults by isolating cascading timeout handling to auth processes. {{}},{{}},{{}},{{}} * Renames conflicting random number functions to prevent data race issues. {{}} * Avoids crashes and data races during shutdown by safely managing thread resources and memory clean-up. {{}} #### CDC * Ensures CDC correctly processes transactions involving vector columns by skipping orphan tombstone intents. {{}} * Ensures CDC streams data for non-transactional YCQL tables correctly. {{}} * Ensures unique sorting of batched shard records using `write_id` to prevent data loss. {{}} * Eliminates race conditions in CDC session management, preventing crashes. {{}} * Introduces the `yb_ignore_read_time_in_walsender` parameter for logical replication continuity during upgrades. {{}} * Prevents data loss during restarts by not sending checkpoints if tablet safe time exceeds slot restart time. {{}}
## v2025.1.0.1 - August 5, 2025 {#v2025.1.0.1} **Build:** `2025.1.0.1-b3` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.0.1/yugabytedb-2025.1.0.1-b3-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.0.1/yugabytedb-anywhere-2025.1.0.1-b3-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.0.1-b3 ``` ### Bug fixes #### DocDB * Increases default YSQL lease TTL to 5 minutes to minimize cluster disruptions. {{}} * Disables unnecessary logging when `FLAGS_txn_slow_op_threshold_ms` is set to 0. {{}} * Enhances Kubernetes compatibility by using RPC bind address as hostname in masters. {{}} ## v2025.1.0.0 - July 23, 2025 {#v2025.1.0.0} **Build:** `2025.1.0.0-b168` **Third-party licenses:** [YugabyteDB](https://downloads.yugabyte.com/releases/2025.1.0.0/yugabytedb-2025.1.0.0-b168-third-party-licenses.html), [YugabyteDB Anywhere](https://downloads.yugabyte.com/releases/2025.1.0.0/yugabytedb-anywhere-2025.1.0.0-b168-third-party-licenses.html) ### Downloads **Docker:** ```sh docker pull yugabytedb/yugabyte:2025.1.0.0-b168 ``` ### Highlights **PostgreSQL 15 compatible YugabyteDB clusters** {{}} This is the first stable release featuring a PostgreSQL fork rebase from version 11.2 to 15.0, enabling you to leverage the many key capabilities introduced in PostgreSQL between the two versions. This upgrade brings YSQL API support for numerous features, including stored generated columns, foreign keys on partitioned tables, and non-distinct NULLs in unique indexes. It also introduces query execution optimizations like incremental sort and memoization, along with various observability and security enhancements. We're also pleased to announce that YugabyteDB 2025.1.0.0 supports in-place online upgrades and downgrade—even with the PostgreSQL fork rebased to 15.0. **Note** that the source cluster must be running version 2024.2.3.0 or later to upgrade to version 2025.1.0. For more information, refer to [PostgreSQL 15 features](/v2025.1/api/ysql/pg15-features/). **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](/v2025.1/additional-features/pg-extensions/extension-pgvector/#vector-indexing), enabling faster and more efficient high-dimensional vector lookups. **Automatic transactional xCluster DDL replication** {{}} YugabyteDB now supports seamless replication of YSQL DDL changes across xCluster setups, eliminating the need to manually apply DDLs on both source and target clusters. For more information, refer to [Automatic DDL replication](/v2025.1/deploy/multi-dc/async-replication/async-transactional-setup-automatic/#set-up-automatic-mode-replication). **Parallel queries: Enabling PG parallelism for colocated tables** {{}} Improves query performance for colocated tables by allowing PostgreSQL to leverage multiple CPUs, leading to faster query execution times. For more information, refer to [Parallel queries](/v2025.1/additional-features/parallel-query/). **Optimization for INSERT ON CONFLICT batching** {{}} Queries using the `INSERT ... ON CONFLICT` clause are optimized for efficient execution, with automatic batching applied when multiple statements are executed to improve performance. For more information, refer to [yb_insert_on_conflict_read_batch_size](/v2025.1/reference/configuration/yb-tserver/#yb-insert-on-conflict-read-batch-size). **Cost-Based Optimizer (CBO)** {{}} The CBO leverages YugabyteDB's distributed storage architecture and advanced query execution optimizations, including query pushdowns, LSM indexes, and batched nested loop joins, to deliver PostgreSQL-like performance. For instructions on enabling CBO, refer to [Enable cost-based optimizer](/v2025.1/best-practices-operations/ysql-yb-enable-cbo/). **Bitmap scan support** {{}} Combine multiple indexes for more efficient scans. For instructions on enabling bitmap-scan support, refer to [enable_bitmapscan](/v2025.1/reference/configuration/yb-tserver/#enable-bitmapscan). **Improvement to backward scans** {{}} Fast backward scans are now enabled by default (`use_fast_backward_scan=true`). This improves performance of YSQL backward table scans (for example, a descending-sorted query occurs against a table that is sorted ascending) by up to 10x. ### New features * yugabyted * Support for [upgrading to PG15](/v2025.1/manage/ysql-major-upgrade-yugabyted/) using yugabyted. {{}} * A new yugabyted UI tab displays the [xCluster](/v2025.1/reference/configuration/yugabyted/#xcluster) replication details of the source and destination universe. {{}} * Adds support for IPv6 addresses. {{}} * [Voyager assessment UI enhancements](/stable/yugabyte-voyager/migrate/assess-migration/#get-started-with-migration-assessment) which provide detailed information on migration complexity and breakdown of schema recommendation. {{}} * [Catalog caching](/v2025.1/best-practices-operations/ysql-catalog-cache-tuning-guide/). * Provides ability to find catalog tables which can be preloaded to improve latency for first query in connection or after DDL in the cluster. {{}} * Compressed catalog tuples when storing in the PG catalog cache to reduce the memory consumption. {{}} * Optimized DDL performance by enabling targeted catalog cache invalidation, significantly reducing impact on concurrent DMLs. This avoids rebuilding the entire cache in most cases. {{}} * [Sampling schema in Analyze](/v2025.1/reference/configuration/yb-tserver/#yb-sampling-algorithm). With sampled analyze, the time to analyze a table is no longer proportional to the size of the table. This improvement brings the time to analyze down significantly. For example, time to analyze 1 TB table is down from 35 minutes to under 3 minutes. {{}} * Improved bulk load performance for colocated tables. Introduced a fast path support for bulk load scenarios for colocated tables in particular (controlled by [ysql_colocated_fastpath_txn_copy](/v2025.1/api/ysql/the-sql-language/statements/cmd_copy/#copy-with-fast-path-transaction-for-colocated-tables)) that can improve `COPY` times up to 3x on colocated tables with multiple indexes. {{}} * [Advisory locks](/v2025.1/explore/transactions/explicit-locking/#advisory-locks). Enables session-based and transactional advisory locks for coordination and concurrency control in distributed environments. {{}} * [Non-disruptive adding of indexes for xCluster](/v2025.1/deploy/multi-dc/async-replication/async-transactional-tables/). Adding an index to a database configured with [bi-directional xCluster Replication](/v2025.1/deploy/multi-dc/async-replication/async-deployment/#add-ysql-indexes-in-bidirectional-replication) (or other non-transactional xCluster Replication) is now a non-disruptive, no-downtime operation. {{}} * [PITR-flashback query](/v2025.1/manage/backup-restore/time-travel-query/). Allows querying historical database state by specifying a past timestamp, aiding in auditing, debugging, and data analysis. {{}} * [Foreign key references](/v2025.1/explore/ysql-language-features/advanced-features/partitions/#foreign-key-references). Allows creation of the foreign keys on partitioned tables. {{}} * [NULLS NOT DISTINCT](/v2025.1/api/ysql/the-sql-language/statements/ddl_create_index/#nulls-not-distinct). By default unique indexes treat NULL values as distinct entries (and not equal), allowing multiple nulls for a column. NULLS NOT DISTINCT allows multiple NULL values to be treated equivalently. {{}} * Execution for queries using [ON CONFLICT clause](/stable/develop/best-practices-develop/data-modeling-perf/#upsert-multiple-rows-wherever-possible) are optimized for efficient execution for YugabyteDB distributed architecture. {{}} * [Query Plan Management (QPM)](/v2025.1/launch-and-manage/monitor-and-alert/query-tuning/pg-hint-plan/) introduced to ensure stable and adaptable query performance by preventing plan regression and automatically detecting optimal new plans. {{}} * [YSQL table inheritance](/v2025.1/explore/ysql-language-features/advanced-features/inheritance/). Adds YSQL support for table inheritance using the INHERITS keyword, which allows creating child tables that inherit columns and certain constraints from one or more parent tables. {{}} * [YSQL index consistency checker](/v2025.1/api/ysql/exprs/func_yb_index_check/). yb_index_check() is a built-in utility that helps detect and diagnose index inconsistencies in your database to ensure reliable query results. {{}} * [YSQL lease mechanism](/v2025.1/architecture/transactions/concurrency-control/#ysql-lease-mechanism). Enabled a robust lease mechanism between YB-TServer and YB-Master to enhance fault tolerance and data consistency during network partitions. {{}} * [Transactional DDL](/v2025.1/explore/transactions/transactional-ddl/). Support to align YSQL DDL semantics with PostgreSQL by allowing DDL statements to execute in the main transaction block. {{}} * Added [CDC Logical Replication support](/v2025.1/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. {{}} * [Active Session History](/v2025.1/explore/observability/active-session-history/). Get real-time and historical information about active sessions to analyze and troubleshoot performance issues. {{}} * [PostgreSQL Anonymizer](/v2025.1/additional-features/pg-extensions/extension-pganon/) extension, which masks or replaces personally identifiable information (PII) or commercially sensitive data, is now bundled with Yugabyte. {{}} ### Change log
View the detailed changelog ### Improvements #### YSQL * Added yb_make_next_ddl_statement_nonincrementing to YbDbAdminVariables for yb_db_admin role. {{}} * Enables control over in-place index updates with `yb_enable_inplace_index_update`. {{}} * Enhances initdb logging, correctly handles process termination, and fixes memory leaks on abort signals. {{}} * Ensures cached plans correctly depend on user roles, addressing {{}}. {{}} * Enhances nested loop joins by rechecking pushability of conditions and renames relevant function to reduce confusion. {{}} * Allows setting and modifying options for foreign tables using `ALTER FOREIGN TABLE ...OPTIONS (...)`. {{}} * Allows use of `UNLOGGED` tables syntax, handling it as `LOGGED` with a warning. {{}},{{}} * Exempts walsender from YSQL backend check to prevent index creation delays. {{}} * Enables speculative execution for certain PL statements to avoid unnecessary flushes, enhancing performance. {{}} * Adds `pg_yb_logical_client_version` table to manage session configurations. {{}} * Introduces a dedicated auth-backend for YSQL to handle connection authentication, enhancing security and streamlining the process. {{}} * Ensures correct error handling by adding a missing InvalidOid check in YSQL. {{}} * Enables authentication via a specialized backend, enhancing security and reliability. {{}},{{}} * Enables toggling authentication method in YSQL using the `ysql_conn_mgr_use_auth_backend` flag. {{}} * Adds flag `ysql_conn_mgr_sequence_support_mode` for sequence management options. {{}} * Removes the `enable_ysql_conn_mgr` flag from preview status. {{}} * Allows setting `enable_ysql_conn_mgr` to true for general availability. {{}} * Enhances error transparency when dropping databases or users. {{}} * Supports executing DDL statements in READ COMMITTED isolation with options to disable retries. {{}} * Sets `yb_bnl_batch_size` to 1024 and `yb_prefer_bnl` to true by default, ensuring BNL replace nested loop joins without altering non-NL join plans. {{}} * Adds pg_hint_plan syntax and functionality to control batched nested loop joins, allows setting hints `YbBatchedNL(t1 t2)` and `NoYbBatchedNL`, and modifies `yb_prefer_bnl` handling. Also, it removes BNL dependency on `enable_nestloop` and adjusts cost model. {{}} * Simplifies handling of ybctids from multiple sources in PgDml. {{}} * Allows preloading of foreign key lists in relcache, avoiding on-demand master fetches, controlled by `yb_enable_fkey_catcache`. {{}} * Enables creation of indexes that are covered by the main table. {{}} * Enables faster LZ4 compression for large attributes in YSQL with upgraded third party support. {{}} * Adds notes on pinned objects and script backporting to the README. {{}} * Prevents catalog version bumps on no-op `ALTER ROLE` commands, saving system resources. {{}} * Enhances object creation efficiency by using static factory methods in `PgDML` classes. {{}} * Disables JIT in YB PG15 by default for stability. {{}} * Enhances `INSERT ON CONFLICT` by introducing efficient read batching and adding RETURNING support. {{}} * Enables successful major version upgrades of functions containing semicolons. {{}} * Introduces `GetStatementAs<...>` to simplify `PgStatement*` casts. {{}} * Enables ASH by default for better monitoring and diagnostics. {{}} * Adds `ybctid` as a reserved, fully queryable system column for improved row identification. {{}} * Fixes style issues and lint errors in `ybcModifyTable.c`. {{}} * Simplifies `ybcSetupTargets` by using BMS only, enhancing target column handling. {{}} * Simplifies index requests for co-partitioned vector indexes, enhancing efficiency. {{}} * Excludes third-party extensions from PostgreSQL linter checks. {{}} * Fixes segmentation fault in `CREATE OR REPLACE TRIGGER` by ensuring `ybctid` is set. {{}} * Simplifies DML read pushdown binding for enhanced coding efficiency. {{}} * Ensures `ybcModifyTable.h` meets style guidelines to pass arc lint checks. {{}} * Adds new lint rules for better PostgreSQL code syntax checking {{}} * Resolves style issues in yb_scan.c and yb_scan.h, addressing lint errors and warnings. {{}} * Enhances YSQL code consistency with additional linting rules. {{}} * Adds line breaks for each command in pipelines for better readability. {{}} * Enables transaction-level advisory locks in YugabyteDB when the `ysql_yb_enable_advisory_locks` flag is set to true. {{}} * Reduces CPU usage by optimizing `ExecLockRows` function. {{}} * Adds a flag `ysql_block_dangerous_roles` to prevent privilege escalation. {{}} * Adds new lint rules for comment styles in YSQL code. {{}} * Removes outdated comments that are no longer applicable in the current codebase. {{}} * Ensures YSQL code follows leading whitespace rules and blacklists non-compliant files. {{}} * Streamlines initialization of `YsqlAdvisoryLocksTable` using `std::shared_future`. {{}} * Removes unused parameters from `YBInitPostgresBackend` for cleaner code. {{}} * Simplifies `ysql_dump` by removing outdated references to `pg_tablegroup`. {{}} * Adds a helper class to manage YsqlCatalogConfig updates efficiently. {{}} * Enhances code quality in `pg_yb_utils.c` by applying lint warnings/errors. {{}} * Enhances INSERT ON CONFLICT performance by decoupling batch processing. {{}} * Ensures trailing whitespace issues are consistently addressed in the codebase. {{}} * Allows setting `yb_insert_on_conflict_read_batch_size` to zero to disable batching, aligning closer with PostgreSQL behavior. {{}} * Adjusts `ysqlsh -V` output for accurate command name representation. {{}} * Resolves code style issues by fixing spacing after control statements. {{}} * Streamlines code clarity in YSQL by renaming and conditional updates. {{}} * Streamlines datatype mapping by consolidating multiple code blocks into `PgTypeInfo`. {{}} * Enforces new lint rule `bad_opening_paren` for cleaner code alignment. {{}} * Enhances YSQL logging with new and updated linter rules to reduce errors and increase clarity. {{}} * Enforces new spacing rules around comments in YSQL code. {{}} * Re-enables the `check_for_tables_with_oids` for consistency with PostgreSQL. {{}} * Standardizes type naming across YSQL to eliminate inconsistencies. {{}} * Enables batching for INSERT ON CONFLICT with foreign key triggers. {{}} * Consolidates YSQL configuration parameter management for clarity and consistency. {{}} * Removes unnecessary `needs_pg_session_transaction` field to streamline advisory lock handling. {{}} * Updates error and hint messages for advisory locks to utilize the preview feature. {{}} * Adds "yb" prefix to custom YB type names for clarity and consistency. {{}} * Enables lz4 compression by default for large YSQL tuples, ensuring high performance. {{}} * Reduces `PgClientSession`'s size and streamlines code for better readability and easier modifications. {{}} * Enhances YSQL linter scripts to handle Mac compatibility and prevent failures. {{}} * Simplifies running `pgindent` for cleaner code formatting and resolving issues with function names and comments. {{}} * Removes unnecessary sidecar usage from `YBPgsqlLockOp` for cleaner code. {{}} * Enhances thread safety by isolating `client_` field storage in `PgClientSession`. {{}} * Enhances code readability by running yb_pgindent and manual formatting. {{}} * Enhances `yb_servers` function to include `universe_uuid` for better cluster identification. {{}} * Enables `INSERT ON CONFLICT` read batching by default to increase test coverage. {{}} * Enhances lint rule messages for clarity and stricter comment spacing validation. {{}} * Fixes comment linting issues to handle non-word characters. {{}} * Refactors PgClientSession using the pimpl design pattern for better organization and cleanup. {{}} * Allows customizing `ef_construction` and `m` parameters for ybhnsw indexes during creation. {{}} * Reduces code duplication in query optimization checks for colocated/copartitioned tables. {{}} * Enhances ASH data retrieval in query diagnostics using the SPI framework. {{}} * Allows customization of `ybhnsw` index creation options in YSQL. {{}} * Restores the `ItemPointer` static assert following upstream PostgreSQL code. {{}} * Fixes a TSAN issue by adjusting error reports in YugabyteDB. {{}} * Integrates new data types and functions from pgvector 0.8.0 into YSQL. {{}} * Enables on-demand logging and enhanced catalog cache statistics tracking. {{}} * Enables conditional checks for role existence in `ysql_dump` outputs with the `dump_role_checks` flag. {{}} * Removes the check that the first operation in a plain session must set the read time. {{}} * Enhances code consistency in `ybgate_api.h` by matching PostgreSQL style. {{}} * Consolidates multiple suppression flags into one for cleaner `pg_regress` outputs. {{}} * Refactors `PgDocReadOp` to enhance modularity by isolating sampling logic into `PgDocSampleOp`. {{}} * Restores CREATE permission on the public schema to `yb_db_admin`. {{}} * Enables `ALTER TYPE ... SET SCHEMA` support for Orafce extension upgrades. {{}} * Enhances `pg_stat_get_progress_info` by adding new fields. {{}} * Eliminates unnecessary workaround in `ALTER TABLE` operations related to constraint handling. {{}} * Reinstates checks for `ash_metadata` in PgClient RPC requests with added code explanations. {{}} * Adds support for datetime and UUID type pushdown in mixed mode. {{}},{{}} * Organizes YSQL code by splitting function definitions into a new file. {{}} * Enables expression pushdown for MOD, LIKE, ASCII, SUBSTRING in mixed mode upgrades. {{}} * Disables AutoAnalyze during the entire PG15 upgrade to ensure stability. {{}} * Enforces naming conventions for distinguishing YugabyteDB-specific files. {{}} * Aligns `CurrentMemoryContext` handling more closely with PostgreSQL updates. {{}} * Maintains workaround in `pg_dump` to support upgrades with `pg_stat_statements`. {{}} * Ensures consistent transaction path settings for single-shard operations. {{}} * Merges PostgreSQL 15.12 improvements into YugabyteDB, enhancing database compatibility and stability. {{}} * Allows users to adjust `ybhnsw.ef_search` for HNSW index searches in YSQL. {{}} * Automatically maps `hnsw` to `ybhnsw` in `CREATE INDEX` statements for seamless index creation. {{}} * Recommends changing isolation level to read committed to avoid errors during concurrent inserts. {{}} * Excludes PostgreSQL owned code from `bad_variable_declaration_spacing` lint rule. {{}} * Adds `server_type` option to differentiate foreign servers in `postgres_fdw`. {{}} * Renames `switch_fallthrough` to `yb_switch_fallthrough` for consistency. {{}} * Enables the PostgreSQL Anonymizer extension via the `enable_pg_anonymizer` flag. {{}} * Enhances error reporting by including index names for missing rows. {{}} * Displays rows removed by YugabyteDB index recheck in execution plans. {{}} * Aligns `get_relation_constraint_attnos` function to use correct flag. {{}} * Disallow setting `ysql_select_parallelism` to zero to prevent errors. {{}} * Removes `pg_strtouint64` and adopts `strtoull` or `strtou64` for consistency. {{}} * Aligns YSQL more closely with upstream PostgreSQL, reducing discrepancies and streamlining changes. {{}} * Logs now detail the cause and context of read restart errors for better troubleshooting. {{}} * Adds YB-specific counters to `pg_stat_statements` for detailed stats tracking. {{}} * Limits output buffer to 8kB to ensure compatibility with certain clients. {{}} * Increases the timeout for detecting `pg_yb_catalog_version` mode from 10 seconds to 20 seconds. {{}} * Optimizes catalog version updates on DDL statements to avoid unnecessary refreshes. {{}} * Adds support for `cube` and `earthdistance` extensions in YSQL upgrades. {{}} * Streamlines UPDATE/DELETE operations and standardizes function signatures in YSQL. {{}} * Adds a new YSQL parameter `yb_enable_cbo` for safer query optimization without statistics. {{}} * Enhances accuracy of cost modeling for backward index scans based on the `use_fast_backward_scan` flag. {{}} * Adds support for deferred mode in `yb_read_after_commit_visibility` for writes. {{}} * Reduces unnecessary full catalog cache refreshes by calling update functions atomically. {{}} * Adds estimated roundtrip counts to EXPLAIN output for scans. {{}} * Prevents auto-analyze DDLs from blocking or preempting user DDLs. {{}} * Adds a new YSQL configuration parameter to disable the hint table cache. {{}} * Adds support for LSM index creation on multirange columns. {{}} * Updates the `pg_stat_statements` header to reset stats on upgrade from 2.25 to 2.27. {{}} * Changes default setting of `enable_partitionwise_aggregate` to true, enhancing query performance. {{}} * Enhances the handling of response cache during major version upgrades to prevent errors. {{}} * Streamlines the database by removing obsolete functions related to drop/remove object by OID. {{}} * Enables automatic logging of peak heap snapshots on backend exits for enhanced debugging. {{}} * Enables setting `ysql_yb_enable_cbo` flag on TServer for query optimization. {{}} * Adds verbose logging for Perform RPCs between Pg and TServer via shared memory. {{}} * Enhances code style in `src/backend/tcop/` as per linting reports. {{}} * Adds query ID and leader PID to the `/rpcz` endpoint response. {{}} * Enhances `pg_stats` with length and bounds histograms for better query planning. {{}} * Fixes build failures and enhances memory usage reporting with TCMalloc stats. {{}} * Ensures `CREATE RULE` consistently updates the catalog version across all backends. {{}} #### YCQL * Resolves timestamp precision mismatches in YCQL, aligning inserts and index scans to millisecond precision. {{}},{{}} * Tracks microsecond precision timestamps in YCQL with new metric `cql_microseconds_timestamps_used`. This tracking occurs if the `cql_revert_to_partial_microsecond_support` flag is true. {{}} * Adds keyspace field to `:12000/statements` output. {{}} * Allows setting NULL in YCQL JSONB column values using UPDATE statements. {{}} #### DocDB * Reduces unnecessary attribute map creations during Prometheus metric aggregation. {{}} * Enhances load balancer to prioritize under-replicated tablets first. {{}} * Limits concurrent remote bootstraps per TServer using `load_balancer_max_inbound_remote_bootstraps_per_tserver` flag. {{}} * Enables placing intermediate CA certificates directly in the server cert file for node-to-node encryption. {{}} * 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. {{}} * Prevents overloading by correctly categorizing bootstrapping tablets in load balancing. {{}} * Allows reduction of thread stack size to avoid Linux hugepages backing. {{}} * Upgrades non-FIPS OpenSSL to 3.0.15 and removes CentOS 7 builds. {{}} * Enhances RBS throttling by focusing on active fetch sessions and adjusts expiration logic. {{}},{{}} * Allows dynamic adjustment of `rocksdb_compact_flush_rate_limit_bytes_per_sec` across all tablets. {{}} * Selects geographically closest TServer for faster clone operations. {{}} * Displays detailed RBS progress on the master's Cluster Balancer UI page. {{}},{{}} * Upgrades OpenSSL to version 3.0.16 and enhances aarch64 support. {{}} * Optimizes backward scans by using `Seek` for faster access to recent updates when needed. {{}} * Enables persisting TServer registry entries to the sys catalog, enhancing failover recovery. {{}} * Speeds up backward scans by caching keys, enabling quicker and more efficient data retrieval. {{}} * Initial implementation of Vector LSM supports multi-threaded batch inserts. {{}} * Enables xCluster to support and replicate table rewrite DDL operations effectively. {{}} * Updates and organizes third-party dependencies like `usearch` for better maintainability. {{}} * Simplifies HNSW library structure by using a factory-based approach. {{}} * Allows explicit addition of flags to `gflag_allowlist.txt` for secure callhome data collection, plus `version_info` in TServer data. {{}} * Enables xCluster to handle non-colocated ALTER TABLE commands without pausing replication. {{}} * Passes `automatic_ddl_mode` to xCluster pollers for enhanced replication handling. {{}} * Adds a metric to alert users when the master follower heartbeat delay is too high. {{}} * Removes the need to set `set_cdc_min_replicated_index` during xCluster bootstrap for improved log retention. {{}} * Enables SimSIMD in Usearch for enhanced search operations. {{}} * Reduces thread usage by removing CDC-specific `yb_client` from `PgClientServiceImpl`. {{}} * Adds a `yb-admin` command to remove non-active, blacklisted TServers. {{}} * Skips schema validation for newly added tables in xCluster replication to handle schema changes. {{}} * Standardizes log prefixes for retryable requests with tablet and peer IDs. {{}} * Enables fast backward scans by default, enhancing performance for various workloads. {{}} * Adds a `yb-admin` command to remove tablet servers from the registry. {{}} * Enables persistent TServer registry updates via autoflag configuration. {{}} * Enables persistent storage for vector LSM via separate index chunk files and meta files. {{}} * Enhances Vector LSM handling to maintain data integrity after unexpected restarts. {{}} * Enables the creation of indexable vector columns in DocDB by introducing a new DataType `Vector`. {{}} * Issues NOTICE when creating indexes in bi-directional xCluster to ensure concurrent execution. {{}} * Reduces Python virtual environment changes using `yugabyte-bash-common` for top-level management. {{}} * Renames the vector library to vector_index and updates the namespace accordingly. {{}} * Introduces the `rocksdb_determine_compaction_input_at_start` flag, allowing the selection of SST files for compaction when the task starts rather than when it's queued. {{}} * Creates vector index tablets colocated with the indexed table for effective data retrieval. {{}} * Enables direct replication of specific DDL commands in xCluster. {{}} * Reduces Prometheus metric scrape time from 15 seconds to 2 seconds. {{}} * Reverts a change that issued NOTICE on index creation in bi-directional xCluster setups. {{}} * Enables creation of Vector LSM for tablets with vector indices. {{}} * Removes deprecated vector index storage in RocksDB. {{}} * Reduces argument redundancy in PgsqlReadOperation executions. {{}} * Enables safe index creation on bidirectional xCluster tables without halting operations. {{}} * Replaces `ProducerSchemaPB` with `SchemaVersionsPB` for xCluster configurations. {{}} * Supports DDL replication for additional PostgreSQL objects including foreign tables and text search configurations. {{}} * Enables ALTER operations on colocated tables with active replication. {{}} * Adds packed row support for vector indexes during transaction apply. {{}} * Fetches intents DB for vector index queries to account for unapplied committed transactions. {{}} * Enables building with third party PR artifacts using specific GitHub IDs. {{}} * Enables vector indexes on colocated tables. {{}} * Allows vector index inserts to use a dedicated thread pool, enhancing overall system performance. {{}} * Replaces `vector_index::VertexId` with `StronglyTypedUuid` as `VectorId`. {{}} * Limits concurrent reads on usearch vector index to avoid exceptions. {{}} * Enables file determination at compaction start by default. {{}} * Introduces a system table `pg_advisory_locks` for advisory locks management. {{}} * Enables merging vector index search results across multiple tablets. {{}} * Enhances stability by fixing a missing null check in tablet lookup processes. {{}} * Reduces CPU usage by 3-8% during statistics collection. {{}} * Enables DDL replication for common PostgreSQL extensions in YugabyteDB. {{}} * Clarifies error messages during yb-master initialization. {{}} * Reduces CPU usage by only setting `stmt_max_mem_base_bytes` during `EXPLAIN ANALYZE`. {{}} * Reduces TServer CPU usage by using `serialized_request` size instead of `SpaceUsedLong`. {{}} * Enables advisory lock operations in DocDB, controlled by the flag `yb_enable_advisory_lock`. {{}} * Enables monitoring of long tasks in Reactor threads with `rpc_reactor_task_timeout_ms`. {{}} * Speeds up database creation by batching table lock acquisitions. {{}} * Switches to `GetTableSchema` to check table existence, reducing timeouts. {{}} * Enables explicit release of advisory locks in transactions. {{}} * Enables re-creation of vector indexes on tablet restarts. {{}} * Disables Redis proxy by default to reduce overhead. {{}} * Optimizes RWCLock for faster read operations. {{}} * Disables tablet splitting for tables with vector indexes. {{}} * Removes unnecessary libraries from YB tools, reducing link times and flag count. {{}} * Adds `automatic_ddl_mode` argument to `yb-admin create_xcluster_checkpoint`. {{}} * Enables TSAN for RWCLock, fixing potential deadlocks. {{}} * Refactors lock management code to use static dispatch for compatibility with shared memory. {{}} * Ensures vector indexes are updated during tablet bootstrap if the TServer stops unexpectedly. {{}} * Enhances search by filtering vectors on TServer based on deletion, updates, and criteria. {{}} * Enables remote bootstrap for vector index storage. {{}} * Reduces the need for global mutex locks by introducing per-transaction LockTracker state. {{}} * Ensures DDL unlock operations follow the reverse order of lock operations. {{}} * Enables point-in-time restore support for vector indexes. {{}} * Adds flag `rocksdb_iterator_sequential_disk_reads_factor` to enhance readahead during non-sequential scans. {{}} * Reduces boilerplate for defining hash functions with new helper macros. {{}} * Enables session-level DocDB transactions for advisory locks, ensuring lock validity throughout the session. {{}} * Introduces block-based data organization in `YbHnsw` for efficient memory management during data loading and unloading. {{}} * Introduces deadlock detection for session advisory locks in transactions. {{}} * Resolves session and transaction level advisory lock conflicts in the same session. {{}} * Removes unnecessary `//NOLINT` comments to enhance code readability. {{}} * Replaces heuristic checks with VECTOR data type for column identification. {{}} * Speeds up TServer insert times by enabling variable bloom filtering on RocksDB iterators. {{}} * Speeds up write operations by using `ScopedStatistics`, reducing TServer insert time. {{}} * Enhances deadlock detection to include scenarios with session advisory locks and row-level locks. {{}} * Enables backfilling existing table data when creating vector indexes. {{}} * Removes unnecessary key-value callbacks from vector LSM. {{}} * Allows the creation of colocated tables in xCluster configurations. {{}} * Sets the minimum xCluster safe time lag value to 0 and adds logging for debugging. {{}} * Preserves enum label OIDs during DDL replication across universes. {{}} * Enables YCQL support for `GetTablesEligibleForXClusterReplication`. {{}} * Supports custom vector labels in HNSW library for enhanced indexing flexibility. {{}} * Excludes `AcquireAdvisoryLock` calls from active session history to prevent duplicates. {{}} * Enables use of variable bloom filter during index scans for enhanced query performance. {{}} * Enables logging of YSQL write RPCs with the `print_ysql_write_requests` flag. {{}} * Reduces compile time for `transaction_participant.cc` by removing unused `boost` includes. {{}} * Enables manual compaction of vector index chunks in Vector LSM. {{}} * Supports multiple vector distance functions in ybhnsw index access method. {{}} * Enables chunked vector index backfill and continuation after restart. {{}} * Removes unused `ScanForward` functionality for streamlined performance. {{}} * Ensures vector index backfill reads from the indexed table at the correct time. {{}} * Enables better replication of concurrent DDLs with unique, ordered timestamps. {{}} * Upgrades protobuf to version 21.12 for better C++23 compatibility. {{}} * Updates codebase to C++23, enhancing compatibility and performance. {{}} * Enables sequence replication in xCluster by default, removing the need for a flag. {{}} * Enhances the user message for setting `yb_read_time` to clarify read-only restrictions. {{}} * Adds logging for vector index search stats when `vector_index_dump_stats` flag is true. {{}} * Ensures consistent bootstrapping of vector indexes after a TServer restart. {{}} * Enhances handling of expired snapshots by retrying deletion tasks automatically. {{}} * Correctly displays advisory lock details in `pg_locks` view. {{}} * Ensures vector index contains all entries from the indexed table. {{}} * Adds detailed cluster balancer warnings to the master UI page. {{}} * Adds tombstones to obsolete vector IDs, reducing queries to the main table. {{}} * Displays cluster balancer tasks on the master UI page. {{}} * Adds annotations to prevent compiler reordering in shared memory interactions. {{}} * Uses non-concurrent mode by default for creating vector indexes to streamline processes. {{}} * Enhances xCluster DDL replication by adjusting `yb_read_time` usage and silencing related warnings. {{}} * Renames `docdb::VectorIndex` to `docdb::DocVectorIndex` to eliminate name confusion. {{}} * Allows specific compaction and flush for vector indexes via `yb-admin` commands. {{}} * Adds `yb-ts-cli compact_vector_index` command for tablet-specific vector index compaction. {{}} * Adds `automatic_mode` flag to `create_checkpoint` for simpler xCluster setup. {{}} * Enables dropping vector indexes in DocDB. {{}} * Displays replication mode in the master UI `Outbound Replication Groups` section. {{}} * Enhances vector index compaction with a new deletion API and clearer naming conventions. {{}} * Automatic mode now always requires bootstrapping to ensure OID consistency. {{}} * Reuse threads to enhance connection efficiency in shared memory communication. {{}} * Enhances vector index query stats logging and adds new metrics tracking. {{}} * Enhances monitoring by using thread pool names for thread categorization. {{}} * Simplifies navigation and modification of master async RPC tasks code. {{}} * Introduces idle timeouts in `rpc::ThreadPool` to automatically adjust thread counts based on activity, enhancing resource efficiency. {{}} * Switches to `MPSCQueue` for enhanced single-consumer performance and simpler maintenance. {{}} * Adds support for the DocumentDB extension v0.102-0 to enhance database functionality. {{}} * Enforces shared memory access restrictions at compile time. {{}} * Allows setting `ybhnsw.ef_search` to customize search expansion factor. {{}} * Adds paginated querying for vector index operations. {{}} * Cancels vector index compaction during VectorLSM shutdown. {{}} * Enables cloning of vector indexes in databases. {{}} * Enables consistent backup and restore for vector indexes. {{}} * Renames "Network" wait_event_type to "RPCWait" for clarity. {{}} * Enables `ysql_yb_enable_advisory_locks` by default and makes it a runtime flag. {{}} * Adds detailed logging for failed DDL executions in xCluster replication. {{}} * Enables priority thread pool usage for vector index compactions. {{}} * Enables conditional tracing of ASH events to conserve memory. {{}} * Removes `-ftime-trace` from Clang builds to enhance compatibility with ccache. {{}} * Defers processing of records with commit times exceeding the apply safe time to the next batch. {{}} * Removes outdated code to streamline heartbeat processing. {{}} * Simplifies load balancer placement info management. {{}} * Streamlines tablespace validation by centralizing logic, enhancing future feature support. {{}} * Enhances maintainability by consolidating tablespace validation logic into `TablespaceParser`. {{}} * Deprecates the `load_balancer_count_move_as_add` flag to simplify cluster balancing. {{}} * Enhances gcc12 compilation and streamlines `master_fwd.h` for faster builds. {{}} * Reduces build times by removing unused headers and optimizing file inclusions. {{}} * Reduces query execution latency by optimizing GUC handling in Connection Manager. {{}} #### CDC * Enables asynchronous removal of user tables from CDC streams by adjusting how background threads process and persist stream metadata. {{}} * Enables tablet splitting on tables under CDCSDK stream by default using the flag `enable_tablet_split_of_cdcsdk_streamed_tables`. {{}} * Adds a tag for the slot name attribute in the CDC metrics. {{}} * Blocks creation of `IMPLICIT` streams by default; use flag to override. {{}} * Enhances CDC accuracy by using the minimum of last WAL OP timestamp and transaction start time in segment footers. {{}} * Disables automatic tablet splitting for CDC stream tables by default. {{}} * Removes unused code related to transaction status checks in CDC. {{}} * Enables dynamic table addition in logical replication by default. {{}} * Increases default CDC retention flags to 8 hours for better data durability. {{}} * Enables automatic tablet splitting with logical replication by fixing hidden tablet deletion bugs. {{}} * Reduces unnecessary cleanup requests for logically replicated tables. {{}} * Adds parallel logical replication with consistent tablet subsetting under the `ysql_yb_enable_consistent_replication_from_hash_range` flag. {{}} * Reduces `cdcsdk_publication_list_refresh_interval_secs` to 15 minutes by default. {{}} * Adds `cdcsdk_flush_lag` metric and fixes bugs in other CDC metrics. {{}},{{}} * Limits the number of VirtualWAL instances per TServer with `cdc_max_virtual_wal_per_tserver` flag. {{}} * Enhances CDC streaming by advancing restart time in idle periods, supported by the new flag `cdcsdk_update_restart_time_interval_secs`. {{}} * Reduces logging frequency for certain CDC errors to avoid clutter. {{}} * Sets `wal_status` in `pg_replication_slots` based on CDC consumption timing. {{}} * Corrects flag value conversion to ensure accurate update intervals for CDC restart times. {{}} * Blocks table drops if they are part of a publication to prevent replication issues. {{}} * Reduces the default `yb_walsender_poll_sleep_duration_empty_ms` flag value to 10 ms to speed up replication in sparse workloads. {{}} * Speeds up tablet bootstrap under CDC by skipping initial WAL segments, controlled by `skip_wal_replay_from_beginning_with_cdc` flag. {{}} * Enables `kNoCacheQueryId` to prevent crashes during RocksDB operations. {{}} * Speeds up tablet bootstrap under CDC by fixing WAL replay. {{}} * Automatically removes metrics when a CDC stream is deleted. {{}} * Adds the `cdc_cache_intent_block` flag to control caching of CDC intent blocks. {{}} * Renames the flag to `cdc_enable_caching_db_block` and sets its default to true for enhanced caching. {{}} * Limits CDC GetConsistentChanges response by byte size, allowing toggling with `cdc_use_byte_threshold_for_vwal_changes`. {{}} * Reduces log verbosity in virtual WAL to prevent large log files. {{}} * Increases log visibility for netty errors by changing levels from `DEBUG` to `WARN`. {{}} #### yugabyted * Removes `psutil` dependency in `yugabyted` for better compatibility. {{}} * Enables better handling of complex YSQL configuration parameters using sticky connections. {{}} * Stops sending flags details in the callhome diagnostics to eliminate redundant data. {{}} * Ensures the user interface accurately displays disk size, even when multiple data directories are used. {{}} * Ensures `join` flag in configuration files is properly validated to prevent node misconfiguration. {{}} * Enables `tserver_master_addresses` to update immediately in multi-node deployments using `Yb-ts-cli`. {{}} * Updates column names in `pg_stat_statements` to fix slow queries page on yugabyted UI. {{}} * Increases row count capacity in metrics API by using `int64` instead of `int32`. {{}} * Fixes yb-voyager install instructions layout in yugabyted UI. {{}} * Displays universe UUID instead of a blank in the "Cluster Name" field on the yugabyted-ui settings page. {{}} * Corrects VCPU display in yugabyted-ui for k8s deployments. {{}} * Adds an environment variable to show accurate CPU details in Kubernetes deployments. {{}} * Upgrades yugabyted-ui TypeScript version to 5.0.4 for better package compatibility. {{}} * Adds fully qualified names for non-table SQL objects in the UI. {{}},{{}} * Lists manually refactorable objects by type in the YugabyteD UI. {{}} ### Bug fixes #### YSQL * Resets `current_hint_retrieved` after query execution to ensure consistent hint parsing. {{}} * Introduces a per-database PG new OID allocator, ensuring OID uniqueness in the database and enhancing horizontal scalability in multi-node and multi-tenancy environments. This new mechanism mitigates OID collisions and allows OID consistency in backup-restore scenarios across clusters. A new flag `ysql_enable_pg_per_database_oid_allocator` is provided to return to old OID allocator behavior if necessary. {{}} * Modifies backup/restore process to skip column name checks for indexes, allowing for successful restoration even with renamed columns. {{}} * Enables `ALTER SEQUENCE` commands to change sequence name, schema, and owner without errors. {{}} * Enhances PostgreSQL restart stability by refining shutdown handling and lock file management. {{}} * Reduces memory usage during YugabyteDB connection startup. {{}} * Removes an erroneous log entry that appeared in crashes or errors. {{}} * Enhances protocol flow for consistency in batched query executions using a new flag `ysql_conn_mgr_optimized_extended_query_protocol`. {{}} * Ensures DDL operations continue smoothly by retrying background tasks on polling errors. {{}} * Enables `pg_authid` table prefetching during login to reduce RPCs and prevent errors. {{}} * Ensures Batched Nested Loop joins correctly check for hashable join clauses. {{}} * Reduces XID usage by generating one per `REFRESH MATERIALIZED VIEW CONCURRENTLY` operation. {{}} * Renames on unique constraints now update associated DocDB table names. {{}} * 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. {{}} * Fixes crashes caused by using a RowComparisonExpression on a reordered primary key index. {{}} * Disables in-place index updates by default to address index inconsistency issues. {{}} * Increases YSQL connection manager's thread stack size to 512 KB to prevent crashes on Alma 9 machines. {{}} * Enables creating non-colocated leaf partitions on colocated partitioned tables. {{}} * Ensures joins are only pruned when a Leading hint exists, avoiding errors. {{}} * Fixes flag overlap to differentiate `sticky` settings from `explain` in configurations. {{}} * Standardizes function usage for `ATExecSetTableSpaceNoStorage`to match PostgreSQL's approach. {{}} * Removes an unnecessary code block to streamline backend selection in connection management. {{}} * Corrects tuple ID construction for primary keys with out-of-order columns. {{}} * Restores functionality by removing explicit packet parsing for `yb_is_client_ysqlconnmgr`. {{}} * Reduces read restart errors during concurrent disjoint key writes. {{}} * Enables seamless execution of unnamed prepared statements across different backends. {{}} * Fixes data race in regex pushdown by using thread-local variables. {{}} * Ensures correct row order for queries with IN clauses. {{}} * Tracks sticky connection metrics on the Prometheus endpoint. {{}} * Eliminates segmentation faults caused by a bug in Odyssey's list iteration macro, which incorrectly handled NULL pointers and led to core dumps. {{}} * Avoids unnecessary catalog version bumps during in-place materialized view refreshes. {{}} * Disables index-only scans on copartitioned indexes. {{}} * Allows placement of table replicas in any specified region or zone using `*` wildcard. {{}} * Corrects a queue ordering logic by using `std::lower_bound` to prevent TServer crashes. {{}} * Fixes `ANALYZE` failures on wide tables by adjusting fetch size limits. {{}} * Enhances session stickiness when acquiring session-scoped advisory locks. {{}} * Reduces sequence-related errors when using `ysql_conn_mgr_sequence_support_mode=pooled_with_currval_lastval`. {{}} * Renames `pipe` type to `orafce_pipe` to resolve naming conflicts. {{}} * Eliminates unnecessary file creation for views on temporary tables by checking if storage is actually needed. {{}} * Reduces maintenance time by switching to a less complex implementation of SideBySideDiff.java, thereby eliminating errors from `SideBySideDiff.sanityCheckLinesMatch`. {{}} * Prevents segmentation faults in parallel index scans with aggregate pushdown. {{}} * Introduces custom SQL error codes for better error handling across processes. {{}} * Increases performance by batching index reads during `INSERT ON CONFLICT`, with customizable batch sizes using `yb_insert_on_conflict_read_batch_size`. {{}} * Improves cache re-invalidation for `ALTER TABLE` commands to avoid schema version mismatch errors in the same session. {{}} * Fixes UPDATE errors on partitioned tables by correctly mapping column numbers. {{}} * Ensures restart read time does not exceed the global limit to avoid inconsistent reads. {{}} * Fixes the flaw in the current DDL atomicity workflow where only the first table's schema was compared, even if it doesn't change after a schema version increment. {{}} * Streamlines ysql_dump process by eliminating faulty statements for colocated table unique constraint, enhancing database reliability. {{}} * Introduces batching for the `INSERT ON CONFLICT` command to enhance performance by minimizing alternating read and write operations. Control the batch size with the new YSQL configuration parameter `yb_insert_on_conflict_read_batch_size`, which, when default at `1`, disables batching. {{}} * Fixes crash by skipping internal savepoints for SET/BEGIN in RC isolation. {{}} * Enhances index relation checks with `YBIsCoveredByMainTable` method. {{}} * Alters encoding setup order to ensure `UTF8` use instead of `SQL_ASCII` and adds `pg_collation` to preloaded tables to prevent specific errors. {{}} * Disables LZ4 build option to prevent PostgreSQL build failures. {{}} * Fixes crashes in creating tables with over 585 columns. {{}} * Adds support for `ALTER TABLE VALIDATE CONSTRAINT` in YugabyteDB. {{}} * Prevent incorrect loading of pg_collation catalog caches, eliminating associated performance issues. {{}} * Fixes out-of-bound memory access during index scan cost estimation. {{}} * Blocks `REINDEX` and `TRUNCATE` on system tables using table rewrite. {{}} * Blocks the "NULLS NOT DISTINCT" command until supported. {{}} * Enhances consistency and correctness of INSERT...ON CONFLICT queries via YBCTID infrastructure integration and index management. {{}},{{}} * Assumes indexes contain 1000 rows when statistics are unavailable, ensuring better query planning. {{}} * Enhances performance during nested loop joins by ensuring correct limit resets in colocated index scans. {{}} * Removes time sync service requirement from the prerequisites. {{}} * Enhances UPDATE query execution on generated columns by including them in `updatedCols` calculations. {{}} * Fixes foreign key checks to avoid errors with unique indexes. {{}} * Ensures accurate catalog version tracking during concurrent index creation. {{}} * Automatically restarts the postmaster to prevent stuck processes when a background worker crashes. {{}} * Ensures YB master reads from valid catalog tables during upgrades. {{}} * Re-enables in-place index updates by default after fixing related inconsistencies. {{}} * Prevents DML operations on sequence data during upgrades. {{}} * Fixes `ysql_dump` crashes related to `pg_catalog` schema dumps. {{}} * Accurately estimates the cost of partial index scans by including index conditions. {{}} * Reduces memory usage spikes by using a new memory context for `RelationBuildTriggers`. {{}} * Enhances accuracy of seek-next estimation for index scans and paged results. {{}} * Adds debugging logs to track new OIDs for resolving table OID collisions. {{}} * Ensures successful cache invalidation after a failed ALTER TABLE to prevent "schema mismatch" errors. {{}} * Disables index update optimization by default to fix `ON CONFLICT UPDATE` issues. {{}} * Reverts changes related to `yb_amiscoveredbymaintable` for updated index co-partitioning design. {{}} * Fixes memory leak in `ysql_dump` by clearing PG result in all scenarios. {{}} * Fixes issues with `INSERT ON CONFLICT DO UPDATE` to prevent secondary index corruption. {{}} * Clears session state on retrying a query to avoid errors and conflicts. {{}} * Eliminates background worker restart loops and enhances error handling. {{}} * Fixes "Duplicate table" error by adjusting OID allocation to prevent collisions. {{}} * Replaces `fatal` calls with `pg_fatal` in `pg_dump.c` for better error handling. {{}} * Allows Batch Nested Loop (BNL) joins on partitioned tables in outer joins. {{}},{{}} * Ensures correct handling of `INSERT ... ON CONFLICT DO NOTHING` with multiple arbiter indexes. {{}} * Fixes a missing return statement in `MasterTabletServiceImpl::Write`. {{}} * Ensures all non-fast path UPDATEs correctly fetch the entire row to prevent foreign key violations. {{}} * Fixes crashes when using `yb_get_range_split_clause` with partitioned tables. {{}} * Fixes inconsistency in index entries during concurrent writes in the backfill phase. {{}} * Corrects initialization of `primaryKeyIndex` in `ysql_dump`. {{}} * Removes a faulty assertion in `INSERT ON CONFLICT` to prevent failures. {{}} * Addresses a pending review comment for YSQL style corrections. {{}} * Adds a `tablet state` column to `yb_local_tablets` for clarity on tablet statuses. {{}} * Fixes incorrect error message related to "INSERT ON CONFLICT" under concurrent transactions. {{}} * Corrects batched read behavior for mixed immediate and deferred FK constraints. {{}} * Enhances session management by moving `set_force_catalog_modifications` handling to `PgSession`. {{}} * Reduces scope of `ALTER DATABASE` impact to only the targeted database. {{}} * Enhances code structuring and formatting for query diagnostics files. {{}} * Ensures correct column mapping for partitioned tables during `INSERT ON CONFLICT` updates. {{}},{{}} * Fixes a compile error for GCC builds. {{}} * Reduces latency after DDL changes by using catalog version for cache invalidation. {{}} * Fixes incorrect role name quoting in `ysql_dumpall`. {{}} * Fixes incorrect aggregate column references in flattened subqueries. {{}} * Modifies `ysql_dumpall` to combine `CREATE ROLE` and `ALTER ROLE` for effective role management. {{}} * Fixes an error in UPDATE queries setting the primary key to itself. {{}} * Fixes issues with `INSERT ON CONFLICT` queries using `SPI_execute_with_args`. {{}} * Reverts `ALTER DATABASE RENAME` and `ALTER DATABASE OWNER` to global impact. {{}} * Fixes memory leaks and segmentation faults in YSQL Connection Manager. {{}} * Fixes memory leaks in the PostgreSQL Anonymizer extension and optimizes test scheduling. {{}} * Fixes potential negative cost calculations for large table scans by using `double` for estimates. {{}} * Fixes `\d` command for indexes with spaces in their names. {{}} * Prevents returning corrupt data for `INSERT ON CONFLICT` with `RETURNING` when read batching is enabled. {{}} * Ensures `CREATE OR REPLACE VIEW` refreshes the catalog for immediate update visibility. {{}} * Refines cost model tuning using server-side execution times for more accurate query optimization. {{}} * Enhances linter hints for Mac users by prioritizing `brew` over `apt`. {{}} * Removes redundant `yb_cdc_snapshot_read_time` field, simplifying snapshot management. {{}} * Sets query ID for background workers earlier to ensure correct tracking. {{}} * Enhances estimation of result tuple size in edge cases, preventing division by zero errors. {{}} * Enables geolocation costing in the new cost model using the `yb_enable_geolocation_costing` flag. {{}} * Fixes flaky behavior in Connection Manager when handling prepared statements. {{}} * Disables fast-path transactions for bulk loads on colocated tables by default. {{}} * Refactors the FK cache handling in YSQL for cleaner code structure. {{}} * Optimizes cost modeling for primary index scans to assume sequential disk block fetching. {{}} * Ensures accurate detection of duplicate entries during fast-path transactions. {{}} * Enables setting follower reads YSQL parameters at connection time. {{}} * Resolves multiple issues in tuple-to-string utility functions. {{}} * Ensures stable operation of refresh materialized view during major upgrades. {{}} * Uses auto-generated OID symbols for `pg_proc` entries. {{}} * Displays the `initdb` log file path on stdout for easier debugging. {{}} * Ensures consistent data during fast-path `COPY` operations on tables with unique indexes. {{}} * Enhances query planning for inherited and partitioned tables with more efficient path usage. {{}} * Ensures PostgreSQL compilation only executes necessary tasks by correctly handling `MAKELEVEL`. {{}} * Prevents database crashes by blocking index creation on dimensionless vector columns. {{}} * Fixes upgrade issues for partitioned tables by reverting `relam` settings. {{}} * Prevents crash by excluding NULL values from vector indices. {{}} * Enhances index scans and partition pruning for BOOLEAN conditions. {{}} * Ensures correct behavior of YbBitmapIndexScan upon rescan by updating pushdown expressions. {{}} * Eliminates erroneous colocation data in `indexdef` for copartitioned indexes. {{}} * Restores and repositions a critical statement to its intended location in the planner. {{}} * Enables selective whole row retrieval for DELETE on partitioned tables with varying configurations. {{}} * Corrects estimations for inner table scans in Batched Nested Loop Joins. {{}} * Fixes integer overflow in BNL cost estimation, preventing negative values. {{}} * Prevents incorrect sharing of query limits in subplan executions. {{}},{{}} * Adds a YSQL configuration parameter to customize negative catalog caching. {{}},{{}} * Ensures the `vmodule` flag is respected by the postgres process. {{}} * Adds `liblz4.1.dylib` to macOS `yugabyte-client` package for successful deployment. {{}} * Enables `ANALYZE` to collect accurate stats for parent-level of partitioned tables. {{}} * Prevents crashes by handling non-variable expressions in single-row updates or deletes. {{}} * Adds a safeguard to prevent crashes during NULL vector index scans. {{}} * Enhances stability by initializing vector index scan costs to prevent undefined behavior. {{}} * Prevents relcache reference leaks in `yb_get_ybctid_width`. {{}} * Fixes port conflict issue when setting `pgsql_proxy_bind_address` in dual NIC setups. {{}} * Addresses "Duplicate table" error by ensuring unique OID allocation during restores. {{}} * Ensures YSQL dumps set `colocated = false` for non-colocated databases during backups. {{}} * Reduces default RPC message size limit for better data handling. {{}} * Enhances `yb_index_check` to verify materialized view indexes' consistency. {{}} * Ensures `ysql_dump` maintains enum sort order during backup and restore. {{}} * Ensures accurate data return from index scans by correctly fetching needed values for rechecks. {{}} * Ensures `path->rows` reflects accurate row estimates in scans, avoiding incorrect overwrites. {{}} * Prevents "Duplicate table" errors by not computing `relfilenode_htab` during initdb. {{}} * Ignores the `SPLIT` option when creating a partitioned table. {{}} * Renames YSQL metric prefixes for clarity and maintains compatibility with old names. {{}} * Updates description for `ysql_yb_enable_ash` flag. {{}} * Allows restoration of old backups with enum types without errors by reverting to warnings and auto-generated OIDs. {{}} * Logs odd `pg_enum` OID during restore if `sortorder` is missing, enhancing troubleshooting. {{}} * 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. {{}} * Ensures accurate reset of stats before every `EXPLAIN (ANALYZE)` query. {{}} * Ensures `ybctid` is correctly populated in RETURNING clauses for DML queries. {{}} * Fixes a bug to prevent NULL insertion in `pg_yb_catalog_version`. {{}} * Adds COMMIT as a DDL in YSQL upgrade scripts to handle cache invalidation correctly. {{}} * Restores single-RPC optimization for certain index scans. {{}} * Re-enables password redaction for specific SQL statements in YugabyteDB. {{}} * Adds missing migration script for `pg_hint_plan` extension update. {{}} * Fixes the assertion failure for `ALTER DATABASE OWNER` when using `SELECT FOR UPDATE`. {{}} * Prevents errors by detoasting values before insertion into DocDB tables. {{}} * Ensures `CREATE FUNCTION` also updates the catalog version. {{}} * Removes duplicate YSQL configuration parameter entry. {{}} * Fixes a segfault when rewriting tables with vector indexes. {{}} * Fixes secondary index scan cost estimation on colocated tables. {{}} * Prevents ASAN failures during certain SQL operations. {{}} * Ensures YSQL statistics tables are saved and persist after a database restart. {{}} * Fixes TServer crashes during concurrent metadata changes and tablet destruction. {{}} * Fixes a memory leak in `yb_cancel_transaction` by freeing YbcStatus. {{}} * Disables `yb_force_early_ddl_serialization` by default to avoid conflict errors. {{}} * Ensures PostgreSQL shuts down before deleting upgrade data to prevent crashes. {{}} * Restores performance hints in prepared statements to ensure consistent execution. {{}} * Simplifies descriptions for inherited PostgreSQL wait events. {{}} * Ensures all threads correctly handle signals for consistent shutdown behavior. {{}} * Enables users to control YB query execution plans using `pg_hint_plan`. {{}} * Adds Oracle-like functions to YSQL with the Orafce extension. {{}} #### YCQL * Allows users to control error suppression for `GROUP BY` in YCQL using `ycql_ignore_group_by_error` flag. {{}} * Eliminates unexpected error during shell type definition update across multiple sessions. {{}} #### DocDB * Allows the packed row size to exceed its limit during repacking, preventing TServer crash after `alter table add column` commands with a default value. {{}} * Prevents server crashes during table truncation by safely shutting down iterators before releasing locks. {{}} * Prevents resource waste by checking disk space before remote bootstrap operations. {{}} * Adds a flag to limit multiple pending compactions for priority pools. {{}} * TServers now reject remote bootstrap requests for previously deleted tablets. {{}} * Sets a default 10MB max size for RocksDB MANIFEST files, now configurable via flags. {{}} * Resolves issue where tables could get indefinitely stuck in HIDING state. {{}} * Adds mtime and checksum to block cache key prefix to prevent conflicts. {{}} * Enhances visibility for unexpected rate limiter sleep times in RBS (Remote Bootstrap) threads. {{}} * Prevents crashes when calling `ListMasterServers` RPC on a master by returning an error. {{}} * Upgrades tcmalloc and abseil to prevent crashes from `malloc_usable_size(nullptr)`. {{}} * Prevents creation of tablespaces with duplicate placement blocks. {{}} * Prevents crashes by ensuring non-null frontiers during transaction apply after a TServer restart. {{}} * Fixes load balancing for rewritten tables in colocated databases. {{}} * Prevents deadlocks in PG sessions when using shared memory, enhancing stability. {{}} * Fixes crashes in ProcessSupervisor when unable to restart a process. {{}} * Ensures yb-admin commands respect user-specified timeouts for table flushes and compactions. {{}} * Prevents deadlocks and unresponsiveness during high-load schema changes by fetching table info asynchronously. {{}} * Reduces follower lag by ensuring consistent Raft configuration during tablet splits. {{}} * Ensures accurate replication for transactional writes on xCluster range partitioned tables. {{}} * Ensures post-split compactions complete even if background compactions are in progress. {{}} * Ensures consistent data reads by setting propagated safe time only after successful operation replication. {{}} * Prevents incorrect query results due to invalid seek keys in internal iterator operations. {{}} * Eliminates inconsistencies by not including inactive tablets in `OpenTable` operations. {{}} * Ensures continuous xCluster task operation even if the master temporarily loses the lease but retains leadership. {{}} * Enhances transactional xCluster accuracy by using majority replicated OpId for ApplySafeTime calculations. {{}} * Prevents server deadlocks by skipping `Finished` method during certain task aborts. {{}} * The update stabilizes WriteBuffer, preventing potential crashes when constructed over non-zeroed memory. {{}} * Resolves the shutdown issue with the shared exchange causing TServer to hang by properly managing concurrent threads and session destruction, and sets `pg_client_use_shared_memory` to false by default on Mac to enhance performance. {{}} * Adds a null check to prevent a system crash when cleaning up a recently applied transaction state after a flush operation. {{}} * Prevents crashes during compaction when `ysql_enable_packed_row` is off and existing packed rows are present. {{}} * Updates YSQL migration script to align with PostgreSQL 15 catalog changes. {{}} * Switches pg_cron back to using standard `SIGTERM` handling for cleaner shutdowns. {{}} * Ensures tablets remain effectively managed during transition from RF1 to higher replication factors. {{}} * Ensures consistent tablegroup assignments for colocated table backups without using explicit tablespaces. {{}} * Fixes error for select queries in large tables by adjusting backward scan bounds. {{}} * Eliminates segmentation faults by ensuring `CleanupHiddenTables` holds a write lock during `Upsert`. {{}} * Prevents fatal errors during multiple splits and PITR restores. {{}} * Ensures consistency between `Slice::Less` and `Slice::compare` methods. {{}} * Ensures accurate `WaitForReplicationDrain` behavior by not mislabeling tablets as drained. {{}} * Prevents crash during transaction abort by adjusting lock handling. {{}} * Ensures fast backward scans return accurate results by fully checking row changes. {{}} * Enables cloning databases to any time in the snapshot schedule retention period. {{}} * Enables `lock_timeout` for advisory locks, enhancing timeout precision. {{}} * Fixes handling of `db_max_flushing_bytes` to properly limit memory usage under high write loads. {{}} * Fixes crashes when executing `SELECT * FROM pg_locks` during advisory lock waits. {{}} * Prevents unbounded growth of the `recently_applied_map` by not adding read-only transactions, conserving memory. {{}} * Prevents data loss by ensuring databases are flushed before updating flush markers. {{}} * Fixes a bug that caused vector indexes to share a folder, preventing crashes. {{}} * Fixes HTTP 503 response formatting on Master API requests. {{}} * Fixes crashes in handling session advisory lock statuses. {{}} * Ensures successful remote bootstrap by removing pre-existing directories. {{}} * Adjusts `DocRowwiseIterator` to correctly include nulls for `NULLS FIRST` sorting. {{}} * Fixes compaction errors from schema version mismatches by storing missing-value info. {{}} * Stops retrying failed batches when the session is closed. {{}} * Prevents TServer crashes during concurrent vector index and read requests. {{}} * Resolves deadlock during TSHeartbeat by adjusting lock scope. {{}} * Eliminates potential deadlocks in thread pool by fixing a race condition. {{}} * Ensures "create table" requests for colocated tables don't fail due to mistaken tablet limit checks. {{}} * Reduces unnecessary checks when adding tables in alter replication requests. {{}} * Enhances stability by replacing raw pointers with `std::weak_ptr` in tablet server handling. {{}} * Enhances index parameter consistency between Usearch and Hnswlib for balanced performance. {{}} * Ensures correct metadata sequencing for vector index chunks, preventing data inconsistencies. {{}} * Speeds up vector LSM loading by using a thread pool. {{}} * Enables merging of small vector index chunks to enhance search efficiency. {{}} * Fixes shutdown path issues to prevent fatal errors during RPC completion. {{}} * Ensures `pg_txn_start_us` is set for restarted transactions, fixing priority issues in waiter resumption. {{}} * Fixes mini cluster restarts to ensure master leaders track all TServer reconnections. {{}} * Reduces latency by enhancing early resume of RPCs blocked on aborted transactions. {{}} * Fixes memory leak in MasterPathHandlers by properly managing shared pointers. {{}} * Ensures callback triggers after loading tablet server data if the count meets requirements. {{}} * Ensures consistent reads by verifying restart conditions before reporting false corruption. {{}} * Enhances vector index merging for better search efficiency. {{}} * Clarifies the use of "IncludeInactive" and "IncludeHidden" flags in Master RPCs. {{}} * Enables direct mapping from row keys to vector IDs in vector indexes. {{}} * Removes a problematic import to prevent errors during direct script executions in GitHub CI. {{}} * Fixes crashes and errors during vector index creation on non-first column IDs. {{}} * Enhances search efficiency by enabling the Merge function to take vector indexes as input for compactions. {{}} * Fixes crashes when copying large rows with a vector index. {{}} * Updates Snappy to version 1.1.8.4 for better M1 Mac support. {{}} * Fixes snapshot deletion during unfinished operations. {{}} * Enhances XClusterSafeTimeService by integrating it with the upgraded Poller class. {{}} * Changes xCluster metrics from `kSum` to `kMax` to prevent inaccuracies. {{}} * Eliminates potential crashes when fetching status of sealed transactions. {{}} * Ensures vector indexes are flushed before deleting intents SST files to prevent data loss. {{}} * Enables block-based sampling by default using new YSQL configuration parameters. {{}} * Prevents xCluster failures caused by same-name table re-creation during non-DBScoped DR. {{}} * Fixes a deadlock issue during index creation and enhances conflict detection. {{}} * Reduces false deadlock errors in session advisory lock handling. {{}},{{}} * Ensures correct database IDs are used for xCluster replication setup. {{}} * Disallows write DML operations in time-traveling sessions set with `yb_read_time`. {{}} * Disables pushdown of MD5 and SHA256 to prevent TServer crashes. {{}} * Ensures `pg_locks` functions correctly even with active advisory locks by ignoring advisory lock tablets. {{}} * Corrects the namespace of `TSLocalLockManager` to `yb::tserver`. {{}} * Ensures builds with third party PR artifacts now function correctly. {{}} * Enables cloning databases with sequences to earlier states without errors. {{}} * Enables `pg_locks` to show active PostgreSQL advisory locks. {{}} * Prevents false conflict detection in snapshot isolation operations. {{}} * Fixes lock order for vector index creation to prevent deadlocks. {{}} * Allows xCluster to handle `UNKNOWN` state TableInfos gracefully. {{}} * Disables `-Wmisleading-indentation` warnings in GCC to prevent increased compile times. {{}} * Adjusts shared memory address range to 0x350000000000-0x3f0000000000 to avoid conflicts. {{}} * Ensures continuous leader lease revocation by supporting multiple old leader leases. {{}} * Prevents potential deadlocks by ensuring table locks follow ID order during namespace copies. {{}} * Separates thread pools for vector index backfill and inserts to avoid deadlocks. {{}} * Adds warning for unlocking non-existent advisory locks. {{}} * Escapes non-printable characters in UI and file outputs. {{}} * Fixes logging of partition keys for new child tablets post-split. {{}} * Fixes flush failure reporting during shutdown to prevent data loss. {{}} * Ensures accurate data tracking during master leader transitions by handling chunked tablet reports efficiently. {{}} * Extends advisory lock timeout to 600 seconds to align with PostgreSQL expectations. {{}} * Ensures system tables are correctly removed during deletions or upgrades. {{}} * Reduces thread contention by using a lock-free queue for thread management. {{}} * Enhances local RPC call handling to execute in the same thread when possible. {{}} * Stops tracking transactions when `use_bootstrap_intent_ht_filter` is set to false, preventing memory leaks. {{}} * Ensures `Slice::ToDebugString` respects the `max_len` setting for hex outputs. {{}} * Prevents `yb-admin` crashes by correctly handling argument count for `create_database_snapshot`. {{}} * Improves error handling for shared memory operations in DocDB. {{}} * Removes 60-second timeout upper bound on admin RPCs and adds new `yb_client_admin_rpc_timeout_sec` flag. {{}} * Prevents deadlocks during background compaction and transaction loading. {{}} * Fixes the issue of recording "query id 0" in Active Session History samples. {{}} * Blocks nonconcurrent index creation on xCluster replicated tables. {{}} * Prevents master process crashes by fixing an iteration modification issue in TriggerDdlVerificationIfNeeded. {{}} * Enables `yb-pbc-dump` to decrypt and process encrypted protobuf files using specified keys. {{}} * Ensures `pg_locks` query reliability when a node is down by continuing to serve requests. {{}} * Eliminates the risk of deadlocks during table alterations and snapshot operations. {{}} * Ensures column ID continuity in backups by preserving `next_column_id`. {{}} * Enables YSQL transaction tracing with `pg_client_use_shared_memory` enabled. {{}} * Ensures no deadlock when threads wait on PgResponseCache for query results. {{}} * Increases `RollbackYsqlMajorVersionUpgrade` RPC timeout to 3 minutes. {{}} * Adds race conditions in the odyssey library to the TSAN suppression list. {{}} * Reduces data race when changing RocksDB options during auto-compactions. {{}} * Fixes deadlock issue by adjusting lock acquisition order in HierarchicalNSW. {{}} * Ensures tasks don't hang during shutdown by removing unnecessary checks. {{}} * Rejects alter table requests during table preparation to prevent state inconsistencies. {{}} * Reduces mutex load in Catalog manager by optimizing lock usage. {{}} * Ensures smooth RocksDB shutdown by properly updating compaction counters. {{}} * Fix ensures `/TableExists` correctly identifies recently deleted tables. {{}} * Fixes uninitialized isolation level issue in lock operations. {{}} * Prevents crashes during vector index flush on shutdown. {{}} #### CDC * Allows sending a null "before image" for CDC if `cdc_send_null_before_image_if_not_exists` flag is true. {{}} * Reduces log frequency for certain CDC warnings to every 10 minutes. {{}} * Enhances accuracy of transaction start time logging for better consistency in CDC. {{}} * Fixes memory leaks in the walsender's handling of transactions and file nodes. {{}} * Ensures only relevant `COMMIT` records are streamed, fixing gRPC connector crashes. {{}} * Ensures null values are now correctly captured in CDC before image records. {{}} * Enables removal of dropped tables from the replica identity map to prevent replication errors. {{}} * Excludes expired or irrelevant entries from metrics calculations for more accurate reporting. {{}} * Fixes CDC safe time update to ensure data consistency across tablets. {{}} * Ensures accurate history retention for various replica identities in CDC. {{}} * Reduces untracked memory growth in CDC by eliminating unnecessary request scopes. {{}} * Fixes metric lag by adding dummy entries for expired tablets. {{}} * Stops log cache eviction slowdown due to CDC to prevent untracked memory spikes. {{}} * Prevents CDC crashes by logging a warning for dropped indexes on colocated tables. {{}} * Prevents data loss by not streaming records during transaction load. {{}} * Ensures reliable CDC stream functionality during index creation, preventing schema packing errors. {{}} * Prevents deletion of child tablet entries during metadata cleanup. {{}} * Ensures hidden tablets are accessible during CDC stream fetches to prevent errors. {{}} * Optimizes CDC streams by sending a single BEGIN and COMMIT record for colocated tables. {{}},{{}} * Ensures newly created tables in logical replication are retained correctly during cleanup. {{}} * Handles missing CDC streams gracefully during polling by logging warnings. {{}} * Ensures schema checks during table eligibility evaluations for CDC stream cleanups. {{}} * Reduces log verbosity by changing the log level for virtual WAL destroy statements. {{}} #### yugabyted * Checks for chrony service before enabling ClockBound during node start. {{}} * Preserves the universe key locally after enabling EAR for recovery scenarios. {{}} * Nodes now start using private IP as `advertise_address` instead of hostname. {{}} * Adds `use_client_to_server_encryption` flag to secure login data. {{}}