Greg Sabino Mullane wrote: > On Mon, Apr 29, 2013 at 05:39:22PM +0200, Michelle Sullivan wrote: > ... > >> Removed replication triggers from the tables: commits take: 35 ms per URL >> >> Added triggers, and ran "validate all", truncated tables used.. commit >> takes: 8-10s per URL >> > > Certainly sounds like a locking issue. There is no way the writes themselves > to bucardo_delta are taking that long. Can you check pg_locks during that > 8-10s wait and determine anything of interest, e.g. locks not granted and > waiting? > > > I'm having trouble here... without bucardo (4.x) I get a 10x speed improvement...
Please suggestions on queries and expectations... -- Michelle Sullivan http://www.mhix.org/ _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
