Re: New 8.4 hot standby feature - Mailing list pgsql-general

From Jeff Davis
Subject Re: New 8.4 hot standby feature
Date
Msg-id 1233079689.1243.17.camel@dell.linuxdev.us.dell.com
Whole thread Raw
In response to Re: New 8.4 hot standby feature  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Tue, 2009-01-27 at 12:58 -0500, Merlin Moncure wrote:
> 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.
>

That won't speed up recovery, that will just force the WAL segment to be
archived. It's still up to the standby to find the log and replay it.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Gabi Julien
Date:
Subject: Hot standby
Next
From: Karsten Hilbert
Date:
Subject: performance advice needed: join vs explicit subselect