]> Untitled Git - lemmy.git/blob - migrations/2023-07-05-000058_person-admin/up.sql
Denormalize community_id into post_aggregates for a 1000x speed-up when loading posts...
[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)