Insert performance degrades as indexes grow large. Indexing in batch is faster than indexing with each insert. http://stackoverflow.com/questions/12206600/how-

Insert performance degrades as indexes grow large. Indexing in batch is faster than indexing with each insert. http://stackoverflow.com/questions/12206600/how-to-speed-up-insertion-performance-in-postgresql http://stackoverflow.com/questions/12206600/how-to-speed-up-... Depending on the nature of your project, you might consider a column store engine for postgres, such as https://github.com/citusdata/cstore_fdw https://github.com/citusdata/cstore_fdw