You should read the documentation for INSERT ... ON CONFLICT. https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT https://www.postgresql.or

You should read the documentation for INSERT ... ON CONFLICT. https://www.postgresql.org/docs/current/sql-insert.html#SQL-ON-CONFLICT https://www.postgresql.org/docs/current/sql-insert.html#SQL-... I'm not sure what's happening with your VACUUM. It does not lock the table without the FULL parameter. Or perhaps your tables have too many indexes?