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... _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
