Tue Jul 18 09:15:12 PDT 2006
- Previous message: [Slony1-general] [Fwd: [Bug 199154] New: Review Request: Slony-1 (postgresql-slony-engine)]
- Next message: [Slony1-general] Partial indices on sl_log_?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Based on discussion with Jan, I have a patch for this... - It comes in as a stored function: addPartialLogIndices() - If it knows that one of the tables is unused (as happens, for instance, after the log switch does a TRUNCATE), then it'll add a partial index for each known origin, and drop any partial indices for "ex-origins." - It is invoked in several places: - After the TRUNCATE in log switching - After MOVE SET, CREATE SET, DROP SET, FAILOVER That should resolve the XXID index concerns...
- Previous message: [Slony1-general] [Fwd: [Bug 199154] New: Review Request: Slony-1 (postgresql-slony-engine)]
- Next message: [Slony1-general] Partial indices on sl_log_?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list