PGConf NYC 2022 Sharding PostgreSQL using Foreign Data Wrappers by Krishna Sarabu

As enterprise data grows at hyperscale, companies are looking for solutions for scaling out databases beyond capacity limits. PostgreSQL supports a variety of Foreign Data Wrappers (FDW) which enables PostgreSQL server to access external remote data stores for sharding, or archiving. The foreign data servers include PostgreSQL, SQL, and NOSQL databases as well as flat files. This session examines foreign data wrappers to scale out and shard your data across PostgreSQL clusters.