Tue Jan 10 10:23:06 PST 2006
- Previous message: [Slony1-general] Problems catching up?
- Next message: [Slony1-general] 1.1.5?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Jan 10, 2006, at 11:57 AM, Ujwal S. Setlur wrote: > Interesting. It took about 24 hours to completely > catch up. st_lag_num_events is now 0. How do I not > leave indexes on the replica? Do I just get rid of the > indexes in the slave database? I have quite a few > indexes on that large table. since you've caught up, no point in deleting the indexes now. i usually create the schema on the replica without indexes, then add them later once the initial copy is done, if that replica actually runs queries. otherwise there's no point in having them...
- Previous message: [Slony1-general] Problems catching up?
- Next message: [Slony1-general] 1.1.5?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list