You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using LSNs to ensure relevant data has replicated from the primary to the secondary in a read replica setup for read-after-write consistency (without citus) and contemplating moving to citus. I haven't been able to find anything in the docs about whether WAL operations such as pg_current_wal_lsn() are supported in citus. Presumably each citus node has its own WAL, is there a shared logical WAL which citus uses, allowing me to continue using this approach, or are such queries impossible?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello folks,
I am using LSNs to ensure relevant data has replicated from the primary to the secondary in a read replica setup for read-after-write consistency (without citus) and contemplating moving to citus. I haven't been able to find anything in the docs about whether WAL operations such as pg_current_wal_lsn() are supported in citus. Presumably each citus node has its own WAL, is there a shared logical WAL which citus uses, allowing me to continue using this approach, or are such queries impossible?
For context, the approach I am taking is explained here: https://brandur.org/postgres-reads
Thanks in advance!
Beta Was this translation helpful? Give feedback.
All reactions