From: Thomas SIMON <tsimon@neteven.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Slow queries in hot standby
Date: Wed, 04 Nov 2015 16:04:35 +0100
Message-ID: <563A1E83.8010208@neteven.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi there,
I have very long queries (exports ; ~2h) that I need to play in my
production cluster.
I have set up master/slave replication in hot standby.
I would like to plan this queries on the sIave, so I'm looking for the
best way to execute this (play with max_standby_archive_delay and
max_standby_streaming_delay ?)
What are the possible side effects with this kind of very long queries
on a slave ?
Thanks,
--
Thomas
--
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: tsimon@neteven.com
Subject: Re: Slow queries in hot standby
In-Reply-To: <563A1E83.8010208@neteven.com>
* 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