Technical Deep Dives
Sub-Second Search Across 2.1 Million Documents
TLDR A fast full-text search system built into the database (known technically as a GIN-indexed tsvector) enables sub-second queries across 2.1 million...
#PostgreSQL
4 investigations
Corpus & Data
The 16-Script Pipeline
TLDR A pipeline of 27+ Python scripts transforms 2.1 million raw government documents into a searchable PostgreSQL database with 2.38 million extracted...
Infrastructure
Single PC Pipeline
TLDR The entire 2.1 million document Epstein corpus was processed on a single Windows PC: an Intel i9-13950HX with 24 cores, an NVIDIA RTX 4070 with 8 GB of...
Infrastructure
PostgreSQL Schema
TLDR PostgreSQL 16 serves as the single master database for the entire Epstein corpus analysis. Six core tables hold 2.1 million documents, 2.38 million...