Tue Mar 21 18:33:27 PST 2006
- Previous message: [Slony1-general] General slony maintenance guidelines?
- Next message: [Slony1-general] Fwd: Slon not catching up
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mar 21, 2006, at 11:58 AM, Ujwal S. Setlur wrote: > Are there any general slony maintenance guidelines for > such a scenario? For example, I noticed last night > that sl_log_1 was very big (~25 million entries). Does > slony take care of these things, or do I need to do > anything? Unless your disk system is *wicked* fast, you're not gonna catch up. When my replication falls behind like that, it takes on the order of 5 minutes per event id. And I generate at least a few per minute. I don't know what kind of indexing might make that run any faster -- the time is all spent in the select on sl_log_1 on the origin.
- Previous message: [Slony1-general] General slony maintenance guidelines?
- Next message: [Slony1-general] Fwd: Slon not catching up
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list