Re: Detecting skipped data from logical slots (data silently skipped)

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Detecting skipped data from logical slots (data silently skipped)
Дата
Msg-id 20160816211837.ebcewvxnedsesfmy@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Detecting skipped data from logical slots (data silently skipped)  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: Detecting skipped data from logical slots (data silently skipped)  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
On 2016-08-08 10:59:20 +0800, Craig Ringer wrote:
> Right. Though if we flush lazily I'm surprised the effect is that big,
> you're the one who did the work and knows the significance of it.

It will be. Either you're increasing bloat (by not increasing the
slot's wal position / catalog xmin), or you're adding frequent syncs on
an idle connection.

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [GENERAL] C++ port of Postgres
Следующее
От: Rahila Syed
Дата:
Сообщение: Re: Surprising behaviour of \set AUTOCOMMIT ON