Comment by burmecia

You can create a custom function doing all the delta logic and use pg_cron to schedule it to periodically materialize data using FDW.