Labatt
50-Minute Talk
Postgres has provided an API to build "foreign data wrappers" — extensions that allow queries to execute on external servers — since version 9.3 back in 2011. A robust collection of "FDWs", as they're commonly called, has developed in the years since, while the API itself has greatly expanded and added features, particularly the ability to "pushdown" execution to the external data source.
I come to FDW development with fresh eyes, having inherited the basics from postgres_fdw and clickhouse_fdw to build pg_clickhouse. Now I'd like to share all that I've learned.
This session will cover foreign data wrapper basics, query planning and rewriting, and various techniques to increase pushdown. If at the end you leave with a basic idea where to start and how to build or adopt an FDW for your favorite data sources, it will be a success. And so will you.
