Remove advisory locks that don't serialize on postgres

Four advisory locks are removed because Postgres REPEATABLE READ keeps each transaction on its first snapshot, so the lock never shows the other writer's commit.