We have a primary key of serial type that is incremented automatically based on Postgres sequence.
The problem is this field at midnight start having a big gaps between it values. example:
Id 189040207 189040238 189040239 189040251 189040264 189040265
We don't have delete operation on this tables (we do only soft delete). We are using Postgres 9.3.