Wed Apr 2 14:56:43 PDT 2014
- Previous message: [Slony1-general] Fwd: help tuning to reduce replication lag
- Next message: [Slony1-general] Fwd: help tuning to reduce replication lag
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Apr 2, 2014, at 2:14 PM, Christopher Browne <cbbrowne at afilias.info> wrote: > The disk hardware is pretty zippy and showing no signs of iowait, but it's definitely burning up the CPU and there's no way to thread that up to use more cores in current versions, right? Even if we split the tables across multiple sets, do they still process in serial? > > Yep, they need to process in serial. Not much way to "improve" on that. > > An attempt was made to parallelize processing in the eRServer replication system, a predecessor to Slony, and we had to shut that off in practice. That's what I figured. > > > I would expect Slony version 2.2 to be a fair bit quicker, as it uses COPY protocol to copy the data in, which dramatically reduces the amount of effort that the subscriber server needs to do parsing and planning the SQL for the INSERT/UPDATE/DELETE statements. > > That was going to be my next question! > > Does that help just for the inserts or with the updates/deletes as well? > > It'll help for all three, yep. All going into one stream. Excellent! We'll see about moving forward with an upgrade. It will probably be tricky since we need to quiesce the log tables and we are always fighting this lag. Might have to just drop everything from replication, upgrade, resubscribe. Thanks for the answers! -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20140402/c76b61a1/attachment-0001.htm -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 208 bytes Desc: Message signed with OpenPGP using GPGMail Url : http://lists.slony.info/pipermail/slony1-general/attachments/20140402/c76b61a1/attachment-0001.pgp
- Previous message: [Slony1-general] Fwd: help tuning to reduce replication lag
- Next message: [Slony1-general] Fwd: help tuning to reduce replication lag
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list