Re: Could postgres12 support millions of sequences? (like 10 million)

> > Now I read this paragraph, I realize I was not clear enough.
> > I am saying we do not want to use locks because of all the problems
> > described.
>
> And what I was asking is what locking where you doing?
>
> And it might be better to ask the list how to solve those problems, then
> to create a whole new set of problems by using millions of sequences.
>
> What we are doing in the **OTHER section** with row locks is basically:

BEGIN;
...
x = SELECT last_value + 1 FROM counter WHERE group = ... AND element = ....
FOR UPDATE;
...

if everything is fine, then:
UPDATE counter SET last_value = x WHERE group = ... AND element = ....
FOR UPDATE;
COMMIT;
else:
ROLLBACK;