Welcome to Percona Live Online 2021
Online Open Source Database Conference
Thursday, May 13 • 09:00 - 10:00
Joining Heterogeneous Databases is a reality, not a Myth (PostgreSQL FDW)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
PostgreSQL provides a way to communicate with external data sources. This could be another PostgreSQL instance or any other database. The other database might be a relational database such as Clickhouse, MySQL, or Oracle; or any NoSQL database such as MongoDB or Hadoop. To achieve this, PostgreSQL implements ISO Standard call SQL-MED in the form of Foreign Data Wrappers (FDW). This presentation will explain in detail how PostgreSQL FDWs work. It will include a detailed explanation of simple features and will introduce more advanced features that were added in recent versions of PostgreSQL. Examples of these would be to show how aggregate-pushdown and join-pushdown work in PostgreSQL. The talk will include working examples of these advanced features and demonstrating their use with dierent databases. These examples show how data from dierent database avors can be used by PostgreSQL, including those from heterogeneous relational databases, and showing NoSQL joins.

avatar for Ibrar Ahmed

Ibrar Ahmed

Sr. Software Architect, Percona
Ibrar Ahmed is a Software Architect in Percona LLC. Prior to coming to open source development, he had vast experience in software design and development. His main focus was on system-level embedded development. After joining EnterpriseDB in 2006, an Enterprise PostgreSQL company... Read More →

Thursday May 13, 2021 09:00 - 10:00 EDT
Room #6