On 1/27/09, Gabi Julien <gabi.julien@xxxxxxxxxxxxx> wrote: > I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased > with the experience. This is promising stuff. Perhaps it is a bit too soon to > ask questions here but here it is: > > 1. Speed of recovery > > With a archive_timeout of 60 seconds, it can take about 4 minutes before I see > the reflected changes in the replica. This is normal since, in addition to > the WAL log shipping, it takes more time to do the recovery itself. Still, is > there any way besides the archive_timeout config option to speed up the > recovery of WAL logs on the hot standby? you can manually throw pg_switch_xlog(), In practice, this is more of an issue on development boxes than anything if you server is at all busy. see: http://developer.postgresql.org/pgdocs/postgres/functions-admin.html merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
