Cool new Free software

Posted Dec 19, 2012 16:07 UTC (Wed) by macson_g (guest, #12717)
In reply to: Cool new Free software by man_ls
Parent article: Status.net service to phase out, replaced by pump.io

If you are running PostgreSQL with default configuration and trying to populate your database with INSERTs, then yes, the performance may be less than impressive.

But there is few tricks one can do: 1) use COPY instead of INSERT, 2) loosen reliability guarantees (WAL, sync commits) in configuration, 3) define your table as UNLOGGED.

This will bring your insertion speed close to MongoDB. And probably reliability will still be better than Mongo's.

Cool new Free software

Posted Dec 20, 2012 16:41 UTC (Thu) by pboddie (guest, #50784) [Link]

To get most of the way there, just choose trick #1 in that list. In any book about PostgreSQL performance, that trick should have a chapter by itself consisting of the words "Use COPY instead of INSERT" in very big letters with some smaller print used to clarify stuff like how to do COPY-like operations instead of using the full-privilege COPY, and so on.