This question already has an answer here:
I have come across a problem where PostgreSQL does not insert records at the end of the table (according to id, which is the primary key)
So if, for example I have ids like 1521, 1522, 1527, the id of the next insert will be 1523 and not 1528 as I expected and would like to occur.
The missing ids may be due to the fact that the database that was migrated from MySQL. The id has the following definition: Data type: bigint Default value: nextval('fleetmanager.workorderjob_id_seq'::regclass) Not null Storage: Plain
I use PostgreSQL version 10 on Windows.
How can I get it to always do insert after the last id?