Case study · Government scale
Abhilekh Patal — National Archives of India
The search and order-management backbone for India's national digital archive: 7M+ documents, ~108M metadata records, 30K+ users. PostgreSQL as the source of truth, Solr as the denormalised read model, async workers for everything slow.
- Cut a stalled 7-hour, 92M-row schema migration to 5 hours with temp-table joins and targeted indexes
- Designed hot/cold S3 tiering for 500K+ PDFs to keep archive storage costs flat
- Hardened the public portal against scanner and bot traffic with per-IP rate limiting and WAF rules
- Kept faceted search under 2 seconds on a 7M-document corpus