Built on a full upgrade to PostgreSQL 18.0, IvorySQL 5.0 delivers groundbreaking enhancements to Oracle compatibility, upgraded ecosystem component integrations, and in-depth cloud-native support.

Powered by PostgreSQL 18.0

  • Introduced an asynchronous I/O (AIO) subsystem for significant performance improvements.
  • The pg_upgrade tool: Added a new feature to preserve optimizer statistics.
  • Supported skip scan for multi-column B-tree indexes.
  • New uuidv7() function for time-ordered UUIDs.
  • Virtual generated columns now supported as the default type.
  • Supported OAuth authentication.
  • Enhanced RETURNING clause with OLD and NEW keywords.
  • Time range constraints for PRIMARY KEY, UNIQUE, and FOREIGN KEY.

For more details, see the PostgreSQL 18.0 Release Notes.

21 New Oracle Compatibility Features

IvorySQL 5.0 brings a massive leap in migration capabilities:

  • Oracle-compatible ROWID support for seamless tool migration.
  • PL/iSQL %ROWTYPE and %TYPE support to simplify coding.
  • Empty string to NULL conversion to comply with Oracle compatibility rules.
  • Oracle-compatible SYS_GUID, SYS_CONTEXT, and USERENV functions.
  • Extended OUT parameter support for libpq, stored procedures, and functions.
  • Nested subprograms with support for overloading.
  • Oracle-compatible INSTR function and FORCE VIEW option.

Cloud-Native & Containerization

  • Kubernetes (K8s): Deploy IvorySQL standalone or high-availability clusters via Helm.
  • IvorySQL Operator v5: Adapted for version 5.0 with synchronized component upgrades.
  • IvorySQL Cloud 5.0: A visual managed control plane for the full lifecycle management.
  • Multi-Platform: Packages covering X86, ARM, MIPS, and LoongArch architectures.

Fixed Issues

  • Resolved accurate OID conflict detection in directory tools.
  • Eliminated dangling pointer scenarios in the MainLoop for high concurrency.
  • Fixed test framework assumptions to re-enable end-to-end Oracle compatibility tests.
  • Corrected global unique index enforcement logic across all platforms.

Source Code

Acknowledgements

We express our sincere gratitude to all contributors who made this release possible:

Carlos Chong, ccwxl, Cédric Villemain, Fu Bei, Fawei Zhao, Ge Sui, Grant Zhou, Imran Zaheer, jerome-peng, Jiaoshun Tian, luss, Martin Gerhardy, Mingran Feng, omstack, otegami, Ruike Sun, rophy, Shaolin Chu, Shawn Yan, Shihua Yang, Shiji Niu, Shuisen Tong, shlei6067, sjw1933, Xiangyu Liang, Xiaohui Liu, Xinjie Lv, xuexiaoganghs, Xueyu Gao, yangchunwanwusheng, Yanliang Lei, Yasir Hussain Shah, Yuan Li, Zhe Zhang, Zheng Tao, Zhenhao Pan, Zhuoyan Shi.

Issue Feedback

The community invites you to try IvorySQL 5.0! If you discover bugs, please submit an issue on GitHub Issues.