Slow queries in hot standby

Поиск
Список
Период
Сортировка
От Thomas SIMON
Тема Slow queries in hot standby
Дата
Msg-id 563A1E83.8010208@neteven.com
обсуждение исходный текст
Ответы Re: Slow queries in hot standby
Список 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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade with --link then pg_basebackup for replication
Следующее
От: Keith Fiske
Дата:
Сообщение: Re: Slow queries in hot standby