On Tue, Apr 20, 2010 at 3:48 PM, Andy <angelf...@yahoo.com> wrote: > What is the expected performance impact of the log streaming replication in > 9.0? > > In the past I've used the log shipping replication of MySQL and it caused the > performance of the master to drop by almost 50%. Just wondered if > Postgresql's replication is expected to behave similarly.
Whoa! Sounds like a slow disk IO subsystem, or the inability to take advantage of a fast one. PostgreSQL's PITR replication is already a working part of pgsql. Hot stanbys are due in 9.0, and should produce no more load than they already do in 8.4 or 8.3. Have you tried setting up PITR on pg 8.4 to see how it impacts your server's performance? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
