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:

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.