IvorySQL Blog
Technical deep dives, product updates, and community stories from the IvorySQL team.
The Cost-Comparison Revolution: A Deep Dive into Enhanced PostgreSQL Execution Plan Intervention
How a 1% fuzzy cost comparison silently broke LIMIT and HINT behavior, and how PG 18's new disable_nodes mechanism makes execution plan intervention precise and reliable.
The Great Way Is Simple: PostgreSQL Ops Subtraction and Governance Philosophy for Large-Scale Complex Business
A HOW 2026 talk on taming the exponential complexity of large-scale PostgreSQL operations — from alert storms and configuration drift to the ops-subtraction philosophy, the five knives of governance, and AI-driven monitoring and prediction.
From VACUUM FULL to REPACK: The Evolution of PostgreSQL Table Rewriting
A walk through three generations of PostgreSQL table-rewriting solutions — from the all-locking VACUUM FULL/CLUSTER, to pg_repack's trigger-and-log-table trick, to PG19's kernel-native REPACK built on logical decoding.
The Future Evolution of PostgreSQL Logical Replication
An overview of the future evolution of PostgreSQL logical replication — multi-master conflict detection and automatic resolution, parallel replication, and centralized logical decoding.
IvorySQL Multimodal Fusion in Practice: Collaborative Verification of pgvector + AGE + pg_textsearch in One Instance
A hands-on verification that vector search (pgvector), knowledge graphs (Apache AGE), and BM25 full-text search (pg_textsearch / pg_bigm) can be installed, queried, and fused within a single IvorySQL 5.4 instance.
PostgreSQL 18/19 New Features in Depth: From I/O Prefetch to Intelligent Operations, Elevating the Database Experience
A deep dive into the new features of PostgreSQL 18 and 19, from I/O prefetch and UUID v7 to wait-event history statistics, intelligent vacuum, and adaptive parallel I/O.
Migrating from Oracle to IvorySQL: How Much Code Do You Really Save? A Hands-On Test
A hands-on comparison of Oracle 19c, PostgreSQL 18, and IvorySQL 5.4 on one server — from Oracle syntax, Packages, and transfer transactions to client connectivity — measuring how much migration code really saves.
The “Dilemma” and “Difficulty” of Incremental Checkpoints
Incremental checkpoints in PostgreSQL's shared-storage cluster face two hard problems: ckptq spinlock contention storms and the coupling with full-page writes.
PostgreSQL, the Preferred Companion for Vibe Coding: AI Agent Development's 'Grand Simplicity'
Why PostgreSQL is the ideal AI dev stack: one database for JSON, vector, graph, and time-series data slashes token burn, complexity, and system sprawl.
Postgres_fdw Optimization: GUC Parameter Control for Join Pushdown
How a type-conversion node silently broke Postgres_fdw's Join pushdown, causing a 10,000x slowdown — and how a GUC switch fixed it without touching application SQL.
PostgreSQL Cgroup Memory Management in Cloud Environments
A deep dive into Cgroup v1's memory-accounting blind spots, huge-page tradeoffs, and OOM behavior for PostgreSQL instances running in shared cloud environments.
A Deep Dive into IvorySQL's Oracle De-O Core Solutions
A deep dive into IvorySQL's dual-mode architecture, dual-port dual-parser design, and five-layer compatibility framework for Oracle-to-PostgreSQL migration.
Surprise! IvorySQL Now Syncs Native PG 18.4 Images
A hands-on, real-machine test of pulling native PostgreSQL 18.4 images from the IvorySQL China mirror registry — every pitfall, from tag naming to PG18's breaking data-path change.
IvorySQL Agent: AI-Powered Database Management
How the IvorySQL Agent combines LLMs, tools, and a two-stage smart router to deliver unified monitoring, diagnostics, and operations for IvorySQL and PostgreSQL.
Why Can Oracle Run on PostgreSQL? The Answer Lies in the Kernel
A source-level look at how IvorySQL achieves deep Oracle compatibility at the PostgreSQL kernel level — dual parsers, types, packages, and more.
IvorySQL HTAP Real-Time Lakehouse Access Engine
How IvorySQL's HTAP real-time lakehouse access engine eliminates ETL by combining row and column storage in a single database.
IvorySQL Deep Dive: Bridging PostgreSQL Ecosystem and Oracle Compatibility
A deep technical dive into IvorySQL's dual-parser architecture, PL/iSQL compatibility, and Oracle migration path.
20-Minute Image Pull? China Mirror Gets IvorySQL Running in 30 Seconds
A hands-on troubleshooting guide to the IvorySQL China mirror registry — from slow Docker pulls to disk space and connection issues.
PostgreSQL/IvorySQL in Private Cloud Practice
Private cloud database architecture for PostgreSQL and IvorySQL — infrastructure planning, high availability, performance tuning, and intelligent monitoring for enterprise deployments.
HOW 2026 Talk — Open-sourcing a Practical IvorySQL Skills Toolkit for AI Agents
Practical IvorySQL skills and tips from the HOW2026 conference in Jinan, China.
IvorySQL 5.0+ - a game changer for Oracle to PostgreSQL transitions
IvorySQL 5.0+ is a game changer for Oracle to PostgreSQL transitions with PL/iSQL and package support.
In-Depth Analysis of PostgreSQL 18 Key New Features
In-depth analysis of PostgreSQL 18's six key new features including async I/O, UUIDv7, and OAuth.
IvorySQL-WASM, An Exploration Journey of Installation-Free Databases
IvorySQL-WASM enables browser-based database experience with zero installation using WebAssembly.
IvorySQL Incremental Backup and Merge Features
New incremental backup and merge features in IvorySQL for efficient data protection.
Analysis of the Logical Replication Slot Synchronization Feature in IvorySQL v4
IvorySQL v4 introduces logical replication slots for advanced data synchronization.
Analysis of the Invisible Column Feature in IvorySQL 4.0
IvorySQL 4.0 introduces invisible columns for enhanced data modeling flexibility.
IvorySQL 4.0-Design Insights into Oracle Package Compatibility Feature
IvorySQL 4.0 brings comprehensive package compatibility for Oracle migration.
IvorySQL Upgrade Guide-A Smooth Transition from 3.x to 4.0
Complete upgrade guide from IvorySQL 3.x to the major 4.0 release.
External Storage Manager in IvorySQL Database
Explore the IvorySQL external storage manager for flexible data storage options.
IvorySQL High Availability—Zero Loss Logical Replication Slots
Deep dive into IvorySQL high availability architecture with replication and failover.
PGCon2022 meeting review | Technical explanation of IvorySQL project
IvorySQL team shared insights and community progress at PGCon 2022.
Introduction to IvorySQL Packages
IvorySQL now provides package management support for easier installation.
Compiling and Installing IvorySQL on Linux
Step-by-step guide for compiling and installing IvorySQL on Linux systems.
Install software through the YUM source
Learn how to install IvorySQL using YUM package source for streamlined setup.
IvorySQL at PostgresConf SV 2022
IvorySQL presented at PostgresConf SV 2022 with key community updates.
PostgresWorld Webinar | A Deep Dive Into IvorySQL
IvorySQL was featured in the Postgres World Webinar, showcasing Oracle compatibility features.
IvorySQL Has Arrived
IvorySQL has officially arrived — introducing the open source Oracle-compatible PostgreSQL database.