What follows are the release notes for the YugabyteDB v2.25 release series. Content will be added as new notable features and changes are available in the patch releases of the YugabyteDB v2.25 release series. ## Release announcements * [Doubling Down on PostgreSQL Compatibility: YugabyteDB Levels Up with PG15 Features](https://www.yugabyte.com/blog/postgresql-compatibility-new-yugabytedb-pg15-features/) ## v2.25.2.0 - May 20, 2025 {#v2.25.2.0} **Build:** `2.25.2.0-b359` ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2.25.2.0-b359 ``` ### Change log

View the detailed changelog

### New features * yugabyted UI now displays xCluster replication details for the source and destination universe. {{}} ### Improvements #### YSQL * Enhances nested loop joins by rechecking pushability of conditions and renames relevant function to reduce confusion. {{}} * Restores CREATE permission on the public schema to `yb_db_admin`. {{}} * Exempts walsender from YSQL backend check to prevent index creation delays. {{}} * Enables viewing TCMalloc heap snapshots for PG backend processes via new YSQL functions. {{}} * Enhances `yb_servers` function to include `universe_uuid` for better cluster identification. {{}} * Fixes comment linting issues to handle non-word characters. {{}} * Enhances ASH data retrieval in query diagnostics using the SPI framework. {{}} * Allows customization of `ybhnsw` index creation options in YSQL. {{}} * 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`. {{}} * 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. {{}} * Re-adds `bitmap_scans_distinct` test to ensure consistent behavior. {{}} * 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. {{}} * Enhances compatibility with PostgreSQL numeric tests by refining data ordering and simplifying table structures. {{}} * 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. {{}} * Limits output buffer to 8kB to ensure compatibility with certain clients. {{}} * Enhances TServer by adding support for garbage collection of invalidation messages, reducing memory usage. {{}} * Increases the timeout for detecting `pg_yb_catalog_version` mode from 10 seconds to 20 seconds. {{}} * Enhances `pg_stats` with length and bounds histograms for better query planning. {{}} * Fixes build failures and enhances memory usage reporting with TCMalloc stats. {{}} #### YCQL * Allows setting NULL in YCQL JSONB column values using UPDATE statements. {{}} #### DocDB * Enables placing intermediate CA certificates directly in the server cert file for node-to-node encryption. {{}} * Tracks ByteBuffer memory usage with `MemTracker`. {{}} * Allows dynamic adjustment of `rocksdb_compact_flush_rate_limit_bytes_per_sec` across all tablets. {{}} * Selects geographically closest TServer for faster clone operations. {{}} * Switches most builds to clang 19, enhancing code safety and addressing new warnings. {{}} * Introduces block-based data organization in `YbHnsw` for efficient memory management during data loading and unloading. {{}} * Enables manual compaction of vector index chunks in Vector LSM. {{}} * Ensures vector index backfill reads from the indexed table at the correct time. {{}} * 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. {{}} * 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. {{}} * 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. {{}} * Adds safeguard to pause replication after repeated DDL failures. {{}} * 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. {{}} * Simplifies xCluster DDL replication tests by removing bidirectional roles. {{}} * 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. {{}} * Speeds up ExternalMiniCluster tests by directly triggering master elections. {{}} * Deprecates the `load_balancer_count_move_as_add` flag to simplify cluster balancing. {{}} * Removes `master_replication` from `master_fwd.h` to optimize file parsing times. {{}} #### CDC * 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. {{}} * Increases log visibility for netty errors by changing levels from `DEBUG` to `WARN`. {{}} #### yugabyted * Removes `psutil` dependency in `yugabyted` for better compatibility. {{}} ### Bug fixes #### YSQL * Reduces XID usage by generating one per `REFRESH MATERIALIZED VIEW CONCURRENTLY` operation. {{}} * Renames on unique constraints now update associated DocDB table names. {{}} * Reduces read restart errors during concurrent disjoint key writes. {{}} * Avoids unnecessary catalog version bumps during in-place materialized view refreshes. {{}} * Disables index-only scans on copartitioned indexes. {{}} * Introduces custom SQL error codes for better error handling across processes. {{}} * Fixes crashes when using `yb_get_range_split_clause` with partitioned tables. {{}} * Fixes incorrect error message related to "INSERT ON CONFLICT" under concurrent transactions. {{}} * Corrects batched read behavior for mixed immediate and deferred FK constraints. {{}} * Reduces latency after DDL changes by using catalog version for cache invalidation. {{}} * Refines cost model tuning using server-side execution times for more accurate query optimization. {{}} * Removes redundant `yb_cdc_snapshot_read_time` field, simplifying snapshot management. {{}} * 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. {{}} * Restore support for yb_terminated_queries() for PG15. {{}} * 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. {{}} * Organizes tests into separate files for better clarity and maintenance. {{}} * 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. {{}} * Adds unit test to handle `SELECT` errors in incremental cache refresh. {{}} * Fixes regression bug in handling incremental cache refresh across concurrent DDL sessions. {{}} * 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. {{}} * Switches from `now` to `clock_timestamp` for recording invalidation message time. {{}} * 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. {{}} #### DocDB * Resolves issue where tables could get indefinitely stuck in HIDING state. {{}} * 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. {{}} * Enhances transactional xCluster accuracy by using majority replicated OpId for ApplySafeTime calculations. {{}} * Ensures accurate `WaitForReplicationDrain` behavior by not mislabeling tablets as drained. {{}} * Enables cloning databases to any time in the snapshot schedule retention period. {{}} * Fixes handling of `db_max_flushing_bytes` to properly limit memory usage under high write loads. {{}} * Prevents unbounded growth of the `recently_applied_map` by not adding read-only transactions, conserving memory. {{}} * Enables cloning databases with sequences to earlier states without errors. {{}} * 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. {{}} * 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. {{}} * 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. {{}} * Reverts non-printable character handling to fix tests and API scraping issues. {{}} * Prevents crashes during vector index flush on shutdown. {{}} #### CDC * Ensures only relevant `COMMIT` records are streamed, fixing gRPC connector crashes. {{}} * 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. {{}} #### yugabyted * Checks for chrony service before enabling clockbound during node start. {{}} * Preserves the universe key locally after enabling EAR for recovery scenarios. {{}}

## v2.25.1.0 - March 21, 2025 {#v2.25.1.0} **Build:** `2.25.1.0-b381` ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2.25.1.0-b381 ``` ### Highlights We're excited to announce the Technical Preview of the following powerful new features in YugabyteDB aimed at simplifying operations, enhancing functionality, and improving performance. **Automatic DDL Replication** {{}} xCluster replication currently requires manual execution of DDL statements on both the source and target clusters to ensure schema consistency. [Automatic DDL Replication](/stable/deploy/multi-dc/async-replication/async-transactional-setup-automatic/#set-up-automatic-mode-replication) eliminates this complexity by seamlessly replicating YSQL DDL changes from the source to the target without requiring manual intervention. This ensures: * Effortless schema synchronization across clusters. * Continuous replication without pauses due to schema mismatches. * Improved reliability by handling DDL execution automatically. By automating DDL replication, this feature simplifies database management, reduces operational overhead, and enhances the resilience of xCluster replication. **Advisory locks** {{}} YugabyteDB's latest release introduces support for [PostgreSQL advisory locks](/stable/explore/transactions/explicit-locking/#advisory-locks), enabling efficient application-level locking mechanisms. These locks allow developers to coordinate concurrent processes without blocking transactions, improving workload management and resource synchronization in distributed environments. For more information on PostgreSQL advisory locks, refer to [Advisory locks](https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS) in the PostgreSQL documentation. **Time-travel Queries** {{}} YugabyteDB now supports [time-travel queries](/stable/manage/backup-restore/time-travel-query/), allowing users to run queries as if they were executed at a specified point in the past. This capability enables historical data analysis, auditing, and debugging, without requiring separate backups or snapshots, enhancing data visibility in a running database. **PgVector HNSW Index Support** {{}} YugabyteDB now supports [HNSW (Hierarchical Navigable Small World) indexes](/stable/additional-features/pg-extensions/extension-pgvector/#vector-indexing) via the pgvector extension, enabling efficient approximate nearest neighbor (ANN) search for high-dimensional data. This addition expands YugabyteDB's vector indexing capabilities, providing another option alongside existing indexing methods for vector similarity search. **Upgrade from PostgreSQL 11 to PostgreSQL 15** {{}} YugabyteDB now supports [in-place zero downtime upgrade](/stable/manage/ysql-major-upgrade-yugabyted/) from a PostgreSQL 11-compatible (v2024.2.2) release to a PostgreSQL 15-compatible (v2.25.1) release. This capability allows PostgreSQL major version upgrades without any downtime or interruption to the application. ### New features * [PostgreSQL Anonymizer](/stable/additional-features/pg-extensions/extension-pganon/) extension, which masks or replaces personally identifiable information (PII) or commercially sensitive data, is now bundled with YugabyteDB. {{}} * YugabyteDB now supports the ability to compute multivariate statistics using the [CREATE STATISTICS](https://www.postgresql.org/docs/15/sql-createstatistics.html) command. Part of [PostgreSQL 15](/stable/api/ysql/pg15-features), this feature allows the query planner to use cross-column correlation statistics to generate better query plans. {{}} {{}} ### Change log

View the detailed changelog

### Improvements #### YSQL * Enhances initdb logging, correctly handles process termination, and fixes memory leaks on abort signals. {{}} * Ensures cached plans correctly depend on user roles, addressing {{}}. {{}} * 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. {{}} * Simplifies handling of ybctids from multiple sources in PgDml. {{}} * Enables faster LZ4 compression for large attributes in YSQL with upgraded third party support. {{}} * Enhances `INSERT ON CONFLICT` by introducing efficient read batching and adding RETURNING support. {{}} * Adds `ybctid` as a reserved, fully queryable system column for improved row identification. {{}} * Simplifies index requests for copartitioned vector indexes, enhancing efficiency. {{}} * 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. {{}} * 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. {{}} * 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. {{}} * Enables `INSERT ON CONFLICT` read batching by default to increase test coverage. {{}} * Enhances lint rule messages for clarity and stricter comment spacing validation. {{}} * Refactors PgClientSession using the pimpl design pattern for better organization and cleanup. {{}} * Enhances YSQL index backfill tests to detect and verify index consistency issues more effectively. {{}} * Allows customizing `ef_construction` and `m` parameters for ybhnsw indexes during creation. {{}} * Reduces code duplication in query optimization checks for colocated/copartitioned tables. {{}} * Restores the `ItemPointer` static assert following upstream PostgreSQL code. {{}} * Fixes a TSAN issue by adjusting error reports in YugabyteDB. {{}} * Enhances code style in `src/backend/tcop/` as per linting reports. {{}} * Adds query ID and leader PID to the `/rpcz` endpoint response. {{}} #### YCQL * Adds keyspace field to `:12000/statements` output. {{}} #### DocDB * Enables xCluster to support and replicate table rewrite DDL operations effectively. {{}} * Enables the creation of indexable vector columns in DocDB by introducing a new DataType `Vector`. {{}} * Reduces Prometheus metric scrape time from 15 seconds to 2 seconds. {{}} * Enables building with third party PR artifacts using specific GitHub IDs. {{}} * Enables file determination at compaction start by default. {{}} * 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 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. {{}} * Speeds up certain tests by 1-2 minutes by halting retryable RPC calls during shutdown. {{}} * 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. {{}} * Ensures xCluster safe time service remains operational when the master loses lease. {{}} * 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. {{}} * 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. {{}} * 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. {{}} * Simplifies `PgSamplePicker` by removing its dependency on `PgSelectIndex`. {{}} * 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 correct classification of temporary objects in xCluster automatic mode. {{}} * Enables better replication of concurrent DDLs with unique, ordered timestamps. {{}} * Enhances the user message for setting `yb_read_time` to clarify read-only restrictions. {{}} * Enables sequence replication in xCluster by default, removing the need for a flag. {{}} * Adds logging for vector index search stats when `vector_index_dump_stats` flag is true. {{}} * Ensures vector index backfill reads from the indexed table at the correct time. {{}} * Enhances handling of expired snapshots by retrying deletion tasks automatically. {{}} * Ensures consistent bootstrapping of vector indexes after a TServer restart. {{}} * Changes `xcluster_enable_ddl_replication` to a preview flag for user testing. {{}} * Adds safeguard to pause replication after repeated DDL failures. {{}} * Adds `automatic_mode` flag to `create_checkpoint` for simpler xCluster setup. {{}} * Streamlines tablespace validation by centralizing logic, enhancing future feature support. {{}} * Enhances maintainability by consolidating tablespace validation logic into `TablespaceParser`. {{}} #### CDC * 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. {{}} * 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. {{}} * Enables tests for optimized WAL reads in CDC for TSAN builds. {{}} #### yugabyted * Removes `psutil` dependency in `yugabyted` for better compatibility. {{}} * 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. {{}} ### Bug fixes #### YSQL * 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 Batched Nested Loop joins correctly check for hashable join clauses. {{}} * Enables creating non-colocated leaf partitions on colocated partitioned tables. {{}} * Enables `pg_authid` table prefetching during login to reduce RPCs and prevent errors. {{}} * Standardizes function usage for `ATExecSetTableSpaceNoStorage` to match PG'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`. {{}} * 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. {{}} * Disables index-only scans on copartitioned indexes. {{}} * Fixes crash by skipping internal savepoints for SET/BEGIN in RC isolation. {{}} * Automatically restarts the postmaster to prevent stuck processes when a background worker crashes. {{}} * Enhances accuracy of seek-next estimation for index scans and paged results. {{}} * 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 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. {{}} * 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. {{}} * Fixes incorrect role name quoting in `ysql_dumpall`. {{}} * Ensures DDL operations continue smoothly by retrying background tasks on polling errors. {{}} * Corrects a bug in YugabyteDB where using `yb_enable_expression_pushdown` on aggregates in trivial subqueries with `OFFSET 0` returned values from incorrect columns. {{}} * 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. {{}} * Enables testing of SECURITY LABEL with dummy_seclabel. {{}} * 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. {{}} * Enhances linter hints for Mac users by prioritizing `brew` over `apt`. {{}} * 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. {{}} * Prevents database crashes by blocking index creation on dimensionless vector columns. {{}} * Fixes upgrade issues for partitioned tables by reverting `relam` settings. {{}} * Eliminates erroneous colocation data in `indexdef` for copartitioned indexes. {{}} #### YCQL * Allows users to control error suppression for `GROUP BY` in YCQL using `ycql_ignore_group_by_error` flag. {{}} #### DocDB * Prevents crashes when calling `ListMasterServers` RPC on a master by returning an error. {{}} * 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. {{}} * Ensures consistency between `Slice::Less` and `Slice::compare` methods. {{}} * Prevents crash during transaction abort by adjusting lock handling. {{}} * Ensures accurate `WaitForReplicationDrain` behavior by not mislabeling tablets as drained. {{}} * 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. {{}} * 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. {{}} * Corrects the namespace of `TSLocalLockManager` to `yb::tserver`. {{}} * Ensures builds with third party PR artifacts now function correctly. {{}} * Upgrades tcmalloc and abseil to prevent crashes from `malloc_usable_size(nullptr)`. {{}} * Disables the unstable fast backward scan feature by default in 2.25.1. {{}} * Allows xCluster to handle `UNKNOWN` state TableInfos gracefully. {{}} * Separates thread pools for vector index backfill and inserts to avoid deadlocks. {{}} #### CDC * Reduces log frequency for certain CDC warnings to every 10 minutes. {{}} * 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. {{}} * 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. {{}} * Adds `use_client_to_server_encryption` flag to secure login data. {{}}

## v2.25.0.0 - January 17, 2025 {#v2.25.0.0} **Build:** `2.25.0.0-b489` ### Downloads

**Docker:** ```sh docker pull yugabytedb/yugabyte:2.25.0.0-b489 ``` ### Highlights We're excited to announce the Technical Preview of two foundational features as part of this release. **PostgreSQL 15 Support** {{}} As part of this release, we have upgraded our PostgreSQL fork from version 11.2 to 15.0, enabling you to leverage the many key capabilities introduced in PostgreSQL between these 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. For more information, refer to [PostgreSQL 15 features](/stable/api/ysql/pg15-features/). **Query Diagnostics** {{}} This feature significantly simplifies tuning poorly performing SQL queries by allowing you to capture and export detailed diagnostic information, including bind variables and constants, pg_stat_statements statistics, schema details, active session history, and execution plans. Refer to [Query diagnostics](/stable/launch-and-manage/monitor-and-alert/query-tuning/query-diagnostics/). **Active session history** {{}} In addition, the Active Session History, which provides real-time and historical views of system activity, is now enabled by default. For more information, refer to [Active Session History](/stable/explore/observability/active-session-history/). ### Change log

View the detailed changelog

### Improvements #### YSQL * 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's dependency on `enable_nestloop` and adjusts cost model. {{}} * Enables control over in-place index updates with `yb_enable_inplace_index_update`. {{}} * Added yb_make_next_ddl_statement_nonincrementing to YbDbAdminVariables for yb_db_admin role. {{}} * Allows use of `UNLOGGED` tables syntax, handling it as `LOGGED` with a warning. {{}},{{}} * 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. {{}} * Sets `yb_bnl_batch_size` to 1024 and `yb_prefer_bnl` to true by default, ensuring BNL's replace nested loop joins without altering non-NL join plans. {{}} * Allows preloading of foreign key lists in relcache, avoiding on-demand master fetches, controlled by `yb_enable_fkey_catcache`. {{}} * 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. {{}} * Enables successful major version upgrades of functions containing semicolons. {{}} * Introduces `GetStatementAs<...>` to simplify `PgStatement*` casts. {{}} * Fixes style issues and lint errors in `ybcModifyTable.c`. {{}} * Simplifies `ybcSetupTargets` by using BMS only, enhancing target column handling. {{}} * Excludes third-party extensions from PostgreSQL linter checks. {{}} * Enables creation of indexes that are covered by the main table. {{}} * Enables ASH by default for better monitoring and diagnostics. {{}} * Restores performance hints in prepared statements to ensure consistent execution. {{}} * Updates YSQL upgrade tests for compatibility with pg15. {{}} * Simplifies descriptions for inherited PostgreSQL wait events. {{}} * Enables users to control YB query execution plans using `pg_hint_plan`. {{}} * Adds Oracle-like functions to YSQL with the Orafce extension. {{}} #### YCQL * Resolves timestamp precision mismatches in YCQL, aligning inserts and index scans to millisecond precision. Enables users to optionally revert to microsecond precision using the flag `cql_revert_to_partial_microsecond_support=false`. {{}},{{}} * 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. {{}} #### DocDB * Allows reduction of thread stack size to avoid Linux hugepage backing. {{}} * 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. {{}} * Prevents overloading by correctly categorizing bootstrapping tablets in load balancing. {{}} * 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. {{}},{{}} * Enables persisting TServer registry entries to the sys catalog, enhancing failover recovery. {{}} * Initial implementation of Vector LSM supports multi-threaded batch inserts. {{}} * 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 simple test to verify Vector LSM functionality during and post-insertions. {{}} * 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. {{}} * 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. {{}} * 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. {{}} * Enables selecting compaction files at task start with `rocksdb_determine_compaction_input_at_start` flag. {{}} * Creates vector index tablets colocated with the indexed table for effective data retrieval. {{}} * Enables direct replication of specific DDL commands in xCluster. {{}} * Reverts a change that issued NOTICE on index creation in bi-directional xCluster setups. {{}} * Enables creation of Vector LSM for tablets with vector indices. {{}} * 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. {{}} * Enhances stability by fixing a missing null check in tablet lookup processes. {{}} * Removes deprecated vector index storage in RocksDB. {{}} * Removes outdated code to streamline heartbeat processing. {{}} * Simplifies load balancer placement info management. {{}} * Updates lz4 library to fix a specific compression test failure. {{}} * Increases `RollbackYsqlMajorVersionUpgrade` RPC timeout to 3 minutes. {{}} * Adds race conditions in the odyssey library to the TSAN suppressions 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. {{}} #### CDC * Enables asynchronous removal of user tables from CDC streams by adjusting how background threads process and persist stream metadata. {{}} * Adds a tag for the slot name attribute in the CDC metrics. {{}} * Enables tablet splitting on tables under CDCSDK stream by default using the GFLAG `enable_tablet_split_of_cdcsdk_streamed_tables`. {{}} * Avoids caching IntentDB block reads for CDC to prevent redundant data access. {{}} * Automatically removes metrics when a CDC stream is deleted. {{}} * 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. {{}} #### yugabyted * Enables better handling of complex YSQL configuration parameters using sticky connections. {{}} * Stops sending flag 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 config files is properly validated to prevent node misconfiguration. {{}} * Updates column names in `pg_stat_statements` to fix slow queries page on yugabyted UI. {{}} * Enables `tserver_master_addresses` to update immediately in multi-node deployments using `Yb-ts-cli`. {{}} * 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 * Introduces a per-database PG new OID allocator, ensuring OID uniqueness within 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 GFlag `ysql_enable_pg_per_database_oid_allocator` is provided to return to old OID allocator behavior if necessary. {{}} * Resets `current_hint_retrieved` after query execution to ensure consistent hint parsing. {{}} * 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. Includes killing only Postgres-associated PIDs, using `SIGQUIT` for immediate shutdowns to reduce hang-ups, and monitoring for stuck processes on macOS {{}} * 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. {{}} * Enhances read performance on colocated tables by skipping redundant tombstone checks. {{}} * Fixes flag overlap to differentiate `sticky` settings from `explain` in configurations. {{}} * 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. {{}} * 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. {{}} * Enhances index relation checks with `YBIsCoveredByMainTable` method. {{}} * Alters encoding setup order to ensure `UTF8` use instead of `SQL_ASCII` and adds `pg_collation` to pre-loaded 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 ensuring stable query execution on system catalogs and expression-based indexes when using the `yb_enable_base_scans_cost_model` configuration {{}} * 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. {{}} * 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`. {{}} * 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. {{}} #### 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. {{}} * TServers now reject remote bootstrap requests for previously deleted tablets. {{}} * Sets a default 10MB max size for RocksDB MANIFEST files, now configurable via flags. {{}} * Adds mtime and checksum to block cache key prefix to prevent conflicts. {{}} * Enhances visibility for unexpected rate limiter sleep times in RBS threads. {{}} * Eliminates inconsistencies by not including inactive tablets in `OpenTable` operations. {{}} * 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 "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. {{}} * Adds a flag to limit multiple pending compactions for priority pools. {{}} * Enables merging of small vector index chunks to enhance search efficiency. {{}} * Resolves scheduling of contentious waiters to the correct, larger RPC thread pool. {{}} * 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 re-connections. {{}} * 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. {{}} #### CDC * Allows sending a null "before image" for CDC if `cdc_send_null_before_image_if_not_exists` flag is true. {{}} * 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. {{}} * Fixes memory leaks in the walsender's handling of transactions and file nodes. {{}} * 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. {{}} #### yugabyted * Nodes now start using private IP as `advertise_address` instead of hostname. {{}}