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? -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8
signature.asc
Description: Digital signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
