Horton

Re: Sequence's value can be rollback after a crashed recovery.

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Bossart, Nathan" <bossartn@amazon.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Andy Fan <zhihui.fan1213@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-11-22T20:31:19Z
Lists: pgsql-hackers 
"Bossart, Nathan" <bossartn@amazon.com> writes:
> I periodically hear rumblings about this behavior as well.  At the
> very least, it certainly ought to be documented if it isn't yet.  I
> wouldn't mind trying my hand at that.  Perhaps we could also add a new
> configuration parameter if users really want to take the performance
> hit.

A sequence's cache length is already configurable, no?

			regards, tom lane

Commits

  1. Doc: improve documentation about nextval()/setval().