--- Vivek Khera <[EMAIL PROTECTED]> wrote:
> > On Jan 9, 2006, at 5:29 PM, Ujwal S. Setlur wrote: > > > Thank you. I guess I look at the st_lag_num_events > > field and wait for it to be 0 or close to it? > Right > > now, that number is 6000 and climbing. I started > the > > subscription about 6 hours ago. One of the tables > is > > very large with ~50 million rows or more. > > yes, it could take a while to copy the data... > especially if you left > the indexes on the replica. > 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. Also, I understand that slonyI 1.1.5 will have greatly improved subscribtion performance. Might I see some performance in my case? Thanks, Ujwal _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
