On Fri, Jun 22, 2007 at 05:07:32PM -0500, Shaun Thomas wrote: > But I wonder about something - does slony turn off indexes to facilitate > the data copy, and then reenable them so they're all created after the > copy is done? If that's the case, that could be my problem. 17G is > about the size of all the tables with no indexes, fully vacuumed. If > slony is waiting around forever for the indexes to finish generating > before committing and declaring the initial copy successful, that could > account for my idle time.
Yes, that's how Slony (at least in the versions you're using, IIRC) does it, so it probably is that problem. I think you need to tell your vendor that they need to stop fiddling with connections that might be open in a database. (A lot of what passes for network security is nothing but snake oil, and this would be one example, I think.) A -- Andrew Sullivan | [EMAIL PROTECTED] However important originality may be in some fields, restraint and adherence to procedure emerge as the more significant virtues in a great many others. --Alain de Botton _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
