1. Version Overview

[Release Date: Dec 18, 2025]

IvorySQL 5.1 is built on PostgreSQL 18.1 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements

  • PostgreSQL 18.1

    1. Check for CREATE privileges on the schema in CREATE STATISTICS.

    2. Avoid integer overflow in allocation-size calculations within libpq.

    3. Prevent “unrecognized node type” errors when a SQL/JSON function such as JSON_VALUE has a DEFAULT clause containing a COLLATE expression.

    4. Avoid incorrect optimization of variable-free HAVING clauses with grouping sets.

    5. Do not use parallelism in hash right semi joins.

    6. Avoid possible division-by-zero when creating ordered-append plans.

    7. Fix planner failure with index types that can do ordered access but not index-only scans.

For further details, visit PostgreSQL’s release notes.

3. New Features

  • Upgrade to PG 18.1 kernel: Feature #1004
    PostgreSQL kernel upgraded to version 18.1.

  • Online Experience: IvorySQL 5.1: Feature #6
    An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.1 in real time — no installation required.

  • Packaging for All Platforms: Feature #1136
    Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

  • Containerized Deployment Support
    Supports one-click deployment of standalone or highly available IvorySQL 5.1 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.1 Operator.

  • IvorySQL Cloud 5.1 released (Visual Database Lifecycle Management Platform)
    Offers a fully managed, graphical control plane that handles IvorySQL 5.1 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

  • PostgreSQL Extensions
    Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.

4. Fixed Issues

  • Clear build warnings: Issue #996

  • PL/iSQL Parser Rejects Parentheses in SELECT INTO Expression: Issue #981

  • Doc:Fix reports missing uuid-ossp during source installation: Issue #198

5. Source Code

IvorySQL’s development is maintained across four main repositories:

6. Contributors

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

  • Amberwww1

  • Cédric Villemain

  • Fawei Zhao

  • Ge Sui

  • Grant Zhou

  • Oreo Yang

  • Rophy Tsai

  • Shuntian Jiao

  • Steven Niu

  • Xiangyu Liang

  • Xiaohui Liu

  • Xinjie Lv

  • Xueyu Gao

  • Yasir Hussain Shah

  • Yuan Li

  • Zheng Tao

  • Zhenhao Pan

  • Zhe Zhang

  • Zhibin Wang

  • Zhuoyan Shi