Postgres Pro
Downloads
Home   >   mailing lists

Slow queries in hot standby - Mailing list pgsql-admin

From Thomas SIMON
Subject Slow queries in hot standby
Date
Msg-id 563A1E83.8010208@neteven.com
Whole thread Raw
Responses Re: Slow queries in hot standby  (Keith Fiske <keith@omniti.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade with --link then pg_basebackup for replication
Next
From: Keith Fiske
Date:
Subject: Re: Slow queries in hot standby