Postgres Pro
Downloads
Home   >   mailing lists

Re: sequences vs. synchronous replication - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: sequences vs. synchronous replication
Date
Msg-id f4dd81e9-fc9e-3b71-0a8a-4a5ae345331d@enterprisedb.com
Whole thread Raw
In response to Re: sequences vs. synchronous replication  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: sequences vs. synchronous replication  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: John Naylor
Date:
Subject: Re: speed up verifying UTF-8
Next
From: Robert Haas
Date:
Subject: Re: psql format output