Cost based optimization| Walking with the Elephants
Since v9.1 PostgreSQL is steadily improving its Foreign Data Wrapper (FDW in short) capabilities. FDWs are a way to access and manipulate data external to PostgreSQL from a PostgreSQL server. The technology is based on SQL/MED standard, which represents foreign data in the form of relational table called foreign tables. Starting with v10, PostgreSQL will support declarative partitioning, similar to the partitioning support in many popular DBMSes. What’s more interesting is that these partit...| Walking with the Elephants
PostgreSQL: Aggregate push-down in postgres_fdw It’s exciting times in PostgreSQL for those who are using postgres_fdw or FDW in general. ...| ashutoshpg.blogspot.com
1. Introduction Recently I have been tasked to familiarize myself with the Foreign Data Wrapper (FDW) interface API to build a new FDW capable of doing vertical / columnar sharding, meaning that the FDW is capable of collecting column information from multiple sources and combine them together as a result query. I will document and… Read more The post Implement Foreign Scan With FDW Interface API first appeared on Highgo Software Inc.. The post Implement Foreign Scan With FDW Interface API ...| Highgo Software Inc.