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.
1 comment
[ 4.9 ms ] story [ 9.7 ms ] threadI 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.