Hacker News new | ask | show | jobs
by nunie123 1926 days ago
The data is being moved, it's just that the mechanism to move it was the FDWs, instead of e.g. an Airflow DAG. The FDWs are interesting because they're update-on-query as opposed to updating on a fixed schedule or update on a source system event, which is more common.
1 comments

> The data is being moved

My understanding is that FDW's act as a proxy. I don't believe the tables are materialized.

Can you link me where it says otherwise? I don't see anything in the docs [1].

[1] https://www.postgresql.org/docs/current/postgres-fdw.html