Find rows from a list that do not exist in a PostgreSQL table

You can also find this article on my personal page: https://www.kevinpeters.net/find-rows-from-a-list-that-do-not-exist-in-a-postgre-sql-table

A lot of web applications have to deal with a lot of data. This data has to be saved into some database at some point in time. Those processes are normally done in big batches but making sure that every data entry was inserted into the database is quite hard.

To understand the main problem we are looking here at, let us look at the architecture of a system…