News for hackers. Stuff that matters.

A comment on Build your own “data lake” for reporting purposes. Parent comment

Re:Build your own “data lake” for reporting purposes by nunie123 on Monday March 15, 2021 @09:16AM (#26465702)
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.
[ Parent | on HN ]
Re:Build your own “data lake” for reporting purposes by michael_j_ward on Tuesday March 16, 2021 @05:34PM (#26483353)
> 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

[ Parent | on HN ]