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

From Jeff Davis
Subject Re: Fwd: Re: New 8.4 hot standby feature
Date
Msg-id 1233091544.2820.9.camel@dell.linuxdev.us.dell.com
Whole thread Raw
In response to Fwd: Re: New 8.4 hot standby feature  (Gabi Julien <gabi.julien@broadsign.com>)
Responses Re: Fwd: Re: New 8.4 hot standby feature
List pgsql-general
On Tue, 2009-01-27 at 14:28 -0500, Gabi Julien wrote:
> Could this help? If the logs are smaller then I could potentially afford
> shipping then at a higher frequency.
>

See if there are times during which the recovery process isn't doing
anything (i.e. just waiting for WAL data). If so, something like this
might help. If it's constantly working as hard as it can, then probably
not.

An important question you should ask yourself is whether it can keep up
in the steady state at all. If the primary is producing segments faster
than the standby is recovering them, I don't think there's any way
around that.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: performance advice needed: join vs explicit subselect
Next
From: Tom Lane
Date:
Subject: Re: performance advice needed: join vs explicit subselect