Table: sl_confirm

8.4. Table: sl_confirm

Holds confirmation of replication events. After a period of time, Slony removes old confirmed events from both this table and the sl_event table.

Structure of sl_confirm

con_origin

integer

The ID # (from sl_node.no_id) of the source node for this event

con_received

integer

con_seqno

bigint

The ID # for the event

con_timestamp

timestamp with time zone DEFAULT (timeofday())::timestamp with time zone

When this event was confirmed

Indexes on sl_confirm

sl_confirm_idx1

con_origin, con_received, con_seqno

sl_confirm_idx2

con_received, con_seqno