db fdw

Creator

Creator

Seonglae Cho

Created

Created

2020 Dec 22 7:33

Editor

Editor

Seonglae Cho

Edited

Edited

2024 Apr 24 14:23

Refs

Refs

postgre wip

notion

[PostgreSQL]postgres_fdw

dblink와 마찬가지로 물리적으로 떨어져 있는 원격 테이블에 접속하기 위해 사용합니다. 차이점은 아래에서 설명하겠습니다. 간단하게 설치하는 방법은 CREATE EXTENSION postgres_fdw 입니다. 또한 스키마를 지정하지 않으면 default로 public에 설치가 됩니다. 여기서 유의해야 할 것은 dblink extension이 데이터베이스 내에 설치가 되면 (사용자가 정한 디비 스키마라던지, default인 public 스키마 라던지..) 지우지 않은 이상 재설치가 불가능합니다.

https://brownbears.tistory.com/99

[PostgreSQL]postgres_fdw

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

PostgreSQL 11 sharding with foreign data wrappers and partitioning

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

Foreign Data wrapper type for postgres · Issue #11102 · sequelize/sequelize

Recommendations

////////