Selected managed Postgres with trigram support as the staff search index for low-volume prefix and substring lookups over two identifier types. Shipped migration SQL enabling the extension plus trigram and prefix indexes; live instance provisioning stayed outside the repo.
- What worked
- One transactional store covered both substring and prefix needs without adding a dedicated search cluster to operate.
