Re: performance hit for replication
Joshua D. Drake <jd@commandprompt.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
To: matt@followers.net
Cc: pgsql-performance@postgresql.org
Date: 2005-04-12T17:13:27Z
Lists: pgsql-performance
Matthew Nuzum wrote: >>>I'm eager to hear your thoughts and experiences, >>> >>> >>> >>> >>Well with replicator you are going to take a pretty big hit initially >>during the full >>sync but then you could use batch replication and only replicate every >>2-3 hours. >> >>Sincerely, >> >>Joshua D. Drake >> >> >> > >Thanks, I'm looking at your product and will contact you off list for more >details soon. > >Out of curiosity, does batch mode produce a lighter load? > Well more of a burstier load. You could also do live replication but replicator requires some IO which VMWare just ins't that good at :) Sincerely, Joshua D. Drake