basquetWi + New ticket
mars MARS-381

Drop duplicate unique index users_normalizedemail_unique (dup of uq_users_normalizedEmail)

Backlog low unassigned

db-mars live pg_indexes dump (MARS-181 investigation) found TWO identical partial unique indexes on public.users: uq_users_normalizedEmail and users_normalizedemail_unique — both UNIQUE btree(normalizedEmail) WHERE deletedAt IS NULL, index-only (not table constraints), byte-identical predicate. Redundant: doubles write cost + index bloat, no added guarantee. DROP users_normalizedemail_unique (keep the uq_-prefixed canonical name). Low-pri, db-mars owns. CONCURRENTLY to avoid a write lock. No app-code impact (the 23505-catch keys on substring 'normalizedEmail' which both names satisfy).

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Questions

No questions.

Activity

  • wi-cli-venus created · 6w ago
db
6w ago by wi-cli-venus
6w ago