From: Benjamin Krajmalnik <kraj@servoyant.com>
To: kgrittn@mail.com
To: pgsql-admin@postgresql.org
Subject: Re: Question concerning replicated server using streaming replication used as a read-only reporting server
Date: Thu, 17 Jan 2013 21:49:33 -0700
Message-ID: <007601cdf537$4170d8bb$fa0014ac@stackdump.local> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
thx
Sent from my Verizon Wireless 4G LTE smartphone
Kevin Grittner <kgrittn@mail.com> wrote:
Benjamin Krajmalnik wrote:
> It is ok if I am a little bit behind. What setting do
> I need to tweak to allow it to get further behind?
The relevant settings are described here:
http://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#RUNTIME-CONFIG-REPLICATIONhttp://www.postgresql.org/docs/9.0/interactive/runtime-config-wal.html#RUNTIME-CONFIG-STANDBY
The ones that you might want to look at are:
vacuum_defer_cleanup_age
max_standby_archive_delay
max_standby_streaming_delay
Leaving some gaps for "catch up time" between long-running requests
can help prevent cancelations, since the lag can otherwise
accumulate.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kraj@servoyant.com, kgrittn@mail.com
Subject: Re: Question concerning replicated server using streaming replication used as a read-only reporting server
In-Reply-To: <007601cdf537$4170d8bb$fa0014ac@stackdump.local>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox