Mikhail Shytsko: The Postgres Insert That Fails Right After a Successful Load

A Postgres sequence out of sync with its table breaks the first insert after a data load. Why it happens on serial and identity columns, and how to realign it.