> 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?
>
No I haven't. I'm using MySQL right now. But I want to learn more about Postgresql's Hot Standby and see if it offers a better replication solution.
Can anyone share their experience about Postgresql replication performance impact? Thanks.