One FDW to Rule Them All: A Unified Gateway to Remote SQL Databases
Presented by:

Jonah Harris
Jonah is a long-time developer focused on database internals, high-performance systems, compatibility methods, network protocols, and near-real-time machine learning optimizations. He specializes in data structures, algorithms, and software optimization. In addition to being a recognized expert in Oracle Database, he is also a longstanding PostgreSQL contributor who has served as the CTO of MariaDB (NYSE) and The Meet Group (NASDAQ), and was a founding engineer at EnterpriseDB.
No video of the event yet, sorry!
Foreign Data Wrappers offer a powerful way to integrate external data sources, but their inconsistent implementation, fragmented ecosystem, and suboptimal performance for OLTP workloads limit their usability. This talk introduces a higher-level FDW gateway API and framework for remote SQL-based systems using postgres_fdw as its base, inspired by Oracle Heterogeneous Services and Ingres Enterprise Access. The configuration-driven gateway API employs a single, unified deparser capable of supporting diverse remote systems by leveraging modular functional interfaces that understand the capabilities, mappings, and dialects of each. Optimized for OLTP use cases, it also eliminates redundant deparsing and remote statement parsing/planning, dramatically improving performance while maintaining flexibility. Attendees will learn about the technical design, performance improvements, and practical applications of this implementation, positioning it as a robust addition to the FDW ecosystem.
- Date:
- 2025 March 21 09:30 EDT
- Duration:
- 50 min
- Room:
- Gold Coast 1&2
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Dev
- Difficulty:
- Hard