Re: CREATE REPLICATION SLOT fails on a timeout

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: CREATE REPLICATION SLOT fails on a timeout
Дата
Msg-id 20140516233425.GD9100@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: CREATE REPLICATION SLOT fails on a timeout  (Steve Singer <steve@ssinger.info>)
Ответы Re: CREATE REPLICATION SLOT fails on a timeout
Список pgsql-hackers
On 2014-05-16 17:02:33 -0400, Steve Singer wrote:
> >I don't think that's going to cut it though. The creation can take
> >longer than whatever wal_sender_timeout is set to (when there's lots of
> >longrunning transactions). I think checking whether last_reply_timestamp
> >= 0 during timeout checking is more robust.

> That makes sense.
> A patch that does that is attached.

I've attached a heavily revised version of that patch. Didn't touch all
the necessary places...

Survives creation of logical replication slots under 'intensive
pressure', with a wal_sender_timeout=10ms.

Thanks for the bugreport!

Greetings,

Andres Freund

--
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Вложения

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: %d in log_line_prefix doesn't work for bg/autovacuum workers
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Scaling shared buffer eviction