-- API (search): trigram indexes for people / product name search (`/search?types=people,products`).
-- Apply once, outside a transaction (CONCURRENTLY), or fold into the next numbered migration.
create index concurrently if not exists people_name_trgm_idx on people using gin (name gin_trgm_ops);
create index concurrently if not exists products_name_trgm_idx on products using gin (name gin_trgm_ops);