Vivek Khera vivek
Tue Jan 10 10:23:06 PST 2006
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...




More information about the Slony1-general mailing list