Advanced Database Operations and Performance

Configure a Django project to use PostgreSQL as the database backend.

Explain the purpose of database indexing and create indexes on Django models.

Use `explain()` to analyze query execution plans and identify performance bottlenecks.

Optimize ORM queries by using `select_related` and `prefetch_related` to prevent N+1 problems.

Implement atomic database transactions to ensure data consistency during complex operations.

Explain race conditions and compare pessimistic vs. optimistic locking strategies.

Use `select_for_update()` to implement pessimistic locking in Django.

Implement full-text search capabilities using PostgreSQL's built-in features.