Skip to content

postgrespro/postgres_cluster

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

execplan

PostgreSQL patch & extension for raw query plan execution

This project dedicated to query execution problem in DBMS for computing systems with 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, that the planner at each node will construct same query plan, because different statistics, relation sizes e.t.c.

This solution based on postgres-xl approach: plan tree is serialized by the nodeToString() routine. Further, the serialized plan transfer by new libpq routine called PQsendPlan. In this project we use postgres_fdw connections for management of sessions and remote transactions. Some repeater extension used for the demonstration of plan transfer machinery.

About

Various experiments with PostgreSQL clustering

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 38