PostgreSQL patch & extension for UTILITY queries and query plans execution atremote instance.
Plan is passed by postgres_fdw connection service. It executed by pg_exec_plan()routine, introduced by pg_execplan extension.
This project dedicated to query execution problem in DBMS for computing systemswith cluster architecture.
The DBMS may need to execute an identical query plan at each computing node.Today PostgreSQL can process only SQL statements. But it is not guaranteed, thatthe planner at each node will construct same query plan, because differentstatistics, relation sizes e.t.c.
This solution based on postgres-xl approach: plan tree is serialized by thenodeToString() routine.During serialization we transform all database object identifiers (oid) at eachnode field to portable representation.