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

From Tom Lane
Subject Re: sequences vs. synchronous replication
Date
Msg-id 1637476.1639862832@sss.pgh.pa.us
Whole thread Raw
In response to Re: sequences vs. synchronous replication  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: sequences vs. synchronous replication
List pgsql-hackers
Tomas Vondra <tomas.vondra@enterprisedb.com> writes:
> Here's a PoC demonstrating this idea. I'm not convinced it's the right 
> way to deal with this - it surely seems more like a duct tape fix than a 
> clean solution. But it does the trick.

I was imagining something a whole lot simpler, like "don't try to
cache unused sequence numbers when wal_level > minimal".  We've
accepted worse performance hits in that operating mode, and it'd
fix a number of user complaints we've seen about weird sequence
behavior on standbys.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Chapman Flack
Date:
Subject: Re: Is my home $HOME or is it getpwent()->pw_dir ?
Next
From: Tomas Vondra
Date:
Subject: Re: sequences vs. synchronous replication