thx Sent from my Verizon Wireless 4G LTE smartphone Kevin Grittner <kgrittn@xxxxxxxx> 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-REPLICATION http://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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
