jeudi 21 juillet 2016

Postgres Sequence jumping by 32

We use sequences to maintain the number of orders at a particular business unit. Last few we days, we have noticed that there have been has strange jumps ranging from 1 to 32 in the sequence numbers, multiple times a day. The sequence which we have configured has a cache_value of 1. Why is this happening and how can we resolve this? I couldn't find much documentation regarding the same.

Aucun commentaire:

Enregistrer un commentaire