Avoiding PostgreSQL Pitfalls: The Hidden Cost of Failing Inserts

Using Django create with exception handling for unique constraint violations causes expensive rollbacks and bloat; use ON CONFLICT DO NOTHING via bulk_create(ignore_conflicts) or raw SQL.