On Tue, Mar 07, 2006 at 03:36:57PM +0800, Christopher Kings-Lynne wrote: > > What used to happen is that the tables would gradually get locked, > > piecemeal, as Slony-I got to each one. You could run into deadlock > > problems right near the end, which is a real waste. By locking them > > up front, any failures will take place before any data is copied, so > > this minimizes time wastage. > > Which is exactly why pg_dump does the saem thing.
Wait, are we talking about exclusive locks here? Or do we just aquire shared locks to prevent anyone from running DDL against the objects? -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
