goauthentik / goauthentik/authentik

Add database indexes for `authentik_core_user.email`

Open
#26,170 1 comment 1 reaction 0 assignees View on GitHub
enhancement/confirmed
Dominant language
Python
Stars
25.6k
Forks
2k
Avg merge
1d 2h
Merged PRs (30d)
651

Description

Add database indexes for `authentik_core_user.email`, including case-insensitive lookups such as `UPPER(email::text)`.

Adding appropriate indexes would improve lookup performance and reduce unnecessary database load for deployments that use email as a primary user identifier.

Contributor guide

Open the contributing guide

Research direction

Start by locating the model and migration that define authentik_core_user, then inspect the existing email lookup patterns, including the UPPER(email::text) expression named in the issue. Done means appropriate indexes support case-insensitive email lookups and the resulting queries reduce unnecessary database load.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
backend, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
58/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.