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.
- Ran search on a 3-node SolrCloud cluster — 2 shards × 3 replicas — so queries fan out in parallel across a smaller index per node instead of one instance carrying the full 7.3M-document corpus
- Traced a ZooKeeper node self-registration bug plus a DSpace-vintage solrconfig running against a newer Solr version — fixed both so replica failover actually worked instead of silently failing
- Collapsed a per-document indexing bottleneck (10 short-lived JVMs spun up every 5 minutes) into a single batched reindex call, cutting the GC thrashing that was starving continuous writes
- Tuned soft/hard autocommit intervals against batch size so new records became searchable in near real time without hard-committing on every single write