Hacker News Reader

Possibly nothing more than a side issue, but why are the indexes being created before the bulk insert, rather than after?

Also, a composite index on (reporter_iso, year) instead of individual indexes would work better in a single group-by afaict.