Skip to content

Instantly share code, notes, and snippets.

@matthew-n

matthew-n/pg_changefee.md

Created May 2, 2018 16:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save matthew-n/597bf4907b8f713b1224e0ad5efb6069 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save matthew-n/597bf4907b8f713b1224e0ad5efb6069 to your computer and use it in GitHub Desktop.
Download ZIP
idea for implementing changefeeds in postgresql
Raw
pg_changefee.md

Overview

table -> after trigger (U/I/D) -> eval quals -> write out (old_ctid, new_ctid, table_name, timestamp) to stg client process collects from stg table only one table_name selecting old_ctid and new_ctid for each

@matthew-n
Copy link
Author

matthew-n commented May 2, 2018

https://github.com/sagemathinc/cocalc/blob/master/src/smc-hub/postgres-synctable.coffee

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment