Fun with Foreign Data Wrappers (FDW) and PostgreSQL

Foreign Data Wrappers are problably the most exciting and less known PGSQL feature.

I first saw it used for sharding a big database into several PGSQL servers: They had a frontend PGSQL with a foreign data wrapper and views to route queries to the correct shard. Pretty neat by then.