Re: sequences vs. synchronous replication

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: sequences vs. synchronous replication
Дата
Msg-id f4dd81e9-fc9e-3b71-0a8a-4a5ae345331d@enterprisedb.com
обсуждение исходный текст
Ответ на Re: sequences vs. synchronous replication  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: sequences vs. synchronous replication  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-hackers
On 18.12.21 22:48, Tomas Vondra wrote:
> What do you mean by "not caching unused sequence numbers"? Reducing 
> SEQ_LOG_VALS to 1, i.e. WAL-logging every sequence increment?
> 
> That'd work, but I wonder how significant the impact will be. It'd bet 
> it hurts the patch adding logical decoding of sequences quite a bit.

It might be worth testing.  This behavior is ancient and has never 
really been scrutinized since it was added.



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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: speed up verifying UTF-8
Следующее
От: Robert Haas
Дата:
Сообщение: Re: psql format output