| Slony-I 1.2.23 Documentation | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 1. Schema schemadoc | Fast Forward | Next |
1.16. Table: sl_setsync
SYNC information
Structure of sl_setsync
- ssy_setid
integer PRIMARY KEY REFERENCES sl_set>
ID number of the replication set
- ssy_origin
integer REFERENCES sl_node>
ID number of the node
- ssy_seqno
bigint
Slony-I sequence number
- ssy_minxid
xxid
Earliest XID in provider system affected by SYNC
- ssy_maxxid
xxid
Latest XID in provider system affected by SYNC
- ssy_xip
text
Contains the list of XIDs in progress at SYNC time
- ssy_action_list
text
action list used during the subscription process. At the time a subscriber copies over data from the origin, it sees all tables in a state somewhere between two SYNC events. Therefore this list must contains all XIDs that are visible at that time, whose operations have therefore already been included in the data copied at the time the initial data copy is done. Those actions may therefore be filtered out of the first SYNC done after subscribing.