Slow queries in hot standby

From: Thomas SIMON <tsimon(at)neteven(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Slow queries in hot standby
Date: 2015-11-04 15:04:35
Message-ID: 563A1E83.8010208@neteven.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2015-11-04 16:13:31 Re: Slow queries in hot standby
Previous Message Bruce Momjian 2015-11-04 14:49:58 Re: pg_upgrade with --link then pg_basebackup for replication