Re: New 8.4 hot standby feature

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Gabi Julien <gabi(dot)julien(at)broadsign(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: New 8.4 hot standby feature
Date: 2009-01-27 18:08:09
Message-ID: 1233079689.1243.17.camel@dell.linuxdev.us.dell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2009-01-27 18:12:05 performance advice needed: join vs explicit subselect
Previous Message Merlin Moncure 2009-01-27 17:58:47 Re: New 8.4 hot standby feature