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
Every Epstein Revealed investigation tagged #PostgreSQL — reporting built on court filings, financial records, flight logs, and government document releases. Each article below examines where PostgreSQL appears in the evidence, newest first. Browse the full tag index or all 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...