Seonglae Chopostgre wip
notion
[PostgreSQL]postgres_fdw
dblink와 마찬가지로 물리적으로 떨어져 있는 원격 테이블에 접속하기 위해 사용합니다. 차이점은 아래에서 설명하겠습니다. 간단하게 설치하는 방법은 CREATE EXTENSION postgres_fdw 입니다. 또한 스키마를 지정하지 않으면 default로 public에 설치가 됩니다. 여기서 유의해야 할 것은 dblink extension이 데이터베이스 내에 설치가 되면 (사용자가 정한 디비 스키마라던지, default인 public 스키마 라던지..) 지우지 않은 이상 재설치가 불가능합니다.
https://brownbears.tistory.com/99
![[PostgreSQL]postgres_fdw](https://t1.daumcdn.net/tistory_admin/static/images/openGraph/opengraph.png)
PostgreSQL 11 sharding with foreign data wrappers and partitioning
PostgreSQL 11 sharding with foreign data wrappers and partitioning This document captures our exploratory testing around using foreign data wrappers in combination with partitioning. The idea is to implement partitions as foreign tables and have other PostgreSQL clusters act as shards and hold a subset of the data.
https://about.gitlab.com/handbook/engineering/development/enablement/database/doc/fdw-sharding.html
sequelize
Foreign Data wrapper type for postgres · Issue #11102 · sequelize/sequelize
Describe the solution you'd like Postgres supports Foreign Data Wrappers . It would be amazing for distributed systems to be able to use this feature within sequelize without a hacky work around. This would be a postgres only feature (cu...
https://github.com/sequelize/sequelize/issues/11102
