[HighChaparral]

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

[fnord123]

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