From: Joshua D. Drake <jd@commandprompt.com>
To: matt@followers.net
Cc: pgsql-performance@postgresql.org
Subject: Re: performance hit for replication
Date: Tue, 12 Apr 2005 09:37:01 -0700
Message-ID: <425BF92D.6060004@commandprompt.com> (raw)
In-Reply-To: <425bf664.1fac7adf.258a.5c79@mx.gmail.com>
References: <425bf664.1fac7adf.258a.5c79@mx.gmail.com>
>So, my question is this: My server currently works great, performance wise.
>I need to add fail-over capability, but I'm afraid that introducing a
>stressful task such as replication will hurt my server's performance. Is
>there any foundation to my fears? I don't need to replicate the archived log
>data because I can easily restore that in a separate step from the nightly
>backup if disaster occurs. Also, my database load is largely selects. My
>application works great with PostgreSQL 7.3 and 7.4, but I'm currently using
>7.3.
>
>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.
I am pretty sure Slony has similar capabilities.
Sincerely,
Joshua D. Drake
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, matt@followers.net
Subject: Re: performance hit for replication
In-Reply-To: <425BF92D.6060004@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox