Hi all,

I'm trying to figure out the need for all the indexes that are 
created on the sl_log_* tables... They seem redudant to me:

     "PartInd_ad_sl_log_1-node-1" btree (log_xid _ad.xxid_ops) WHERE 
log_origin = 1
     "PartInd_ad_sl_log_1-node-3" btree (log_xid _ad.xxid_ops) WHERE 
log_origin = 3
     "PartInd_ad_sl_log_1-node-8" btree (log_xid _ad.xxid_ops) WHERE 
log_origin = 8
     "sl_log_1_idx1" btree (log_origin, log_xid _ad.xxid_ops, log_actionseq)

Obviously, to make an index lookup based on log_origin and log_xid, 
one can either use the appropriate partial index or the main index, 
and they would seem to me to do exactly the same thing (there's just 
the little difference with the log_actionseq column). So either the 
partial indexes are really not that useful (my opinion), or the full 
index is a leftover from previous versions, is now obsolete and 
should be removed?

Did I miss something?

Thanks,

Jacques.