Re: Update or Delete causes canceling of long running slave queries

Поиск
Список
Период
Сортировка
От Viswanath
Тема Re: Update or Delete causes canceling of long running slave queries
Дата
Msg-id 1463075663280-5903334.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Update or Delete causes canceling of long running slave queries  (Sameer Kumar <sameer.kumar@ashnik.com>)
Список pgsql-general
Hi,
I am using postgres 9.5
Yes,I restarted the server after changing the autovacuum to off. Also
verified that autovacuum process is not running.

standby db configurations: (mostly default conf only)
hot_standby = on
max_standby_archive_delay = 30s
max_standby_streaming_delay = 30s
wal_receiver_status_interval = 10s
hot_standby_feedback = off
wal_receiver_timeout = 60s
wal_retrieve_retry_interval = 5s



--
View this message in context:
http://postgresql.nabble.com/Update-or-Delete-causes-canceling-of-long-running-slave-queries-tp5903250p5903334.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


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

Предыдущее
От: Viswanath
Дата:
Сообщение: Re: Update or Delete causes canceling of long running slave queries
Следующее
От: "Klaus P. Pieper"
Дата:
Сообщение: ON CONFLICT DO for UPDATE statements