Christopher B. Browne's Home Page
cbbrowne@acm.org

8.3. 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 without time zone DEFAULT (timeofday())::timestamp without 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

Google
Contact me at cbbrowne@acm.org