]> Untitled Git - lemmy.git/blob - migrations/2023-07-05-000058_person-admin/up.sql
improve admin and mod check to not do seq scans and return unnecessary data (#3483)
[lemmy.git] / migrations / 2023-07-05-000058_person-admin / up.sql
1 drop index if exists idx_person_admin;
2 create index idx_person_admin on person(admin) where admin; -- allow quickly finding all admins (PersonView::admins)