On Thursday, March 19, 2020, pabloa98 <
pabloa98@gmail.com> wrote:
We will use a CACHE 1. This is because when nextval('seq') is invoked, we are hitting 3 or 4 more tables so the sequence will not be a performance blocker (compared with all the operations in the transaction).
The other implementation detail to remember is:
“Because nextval and setval calls are never rolled back, sequence objects cannot be used if “gapless” assignment of sequence numbers is needed.”
David J.
