Stop creating a plain index shadowed by the unique one

Shipped: September 16, 2026 at 8:52 PM UTC
Author: Kamo
Commit: 94aab36

member_notification_preferences (member_id) got both a plain and a unique index from the same statement list; the unique index serves every lookup. The plain one was dropped in production on 2026-09-16.

All changes

Like what you see shipping?

All of it arrives in your workspace on its own. Start on the free plan and read this page again in a month.

Start Free Forever View Pricing