News for hackers. Stuff that matters.

tmcallaghan

Re:PostgreSQL Outperforms MongoDB in New Round of Tests on Saturday October 04, 2014 @07:59AM (#8409311)
PostgreSQL indexes are b-trees, and thus will suffer the same performance drop on insert/update/delete as all other b-tree based databases (InnoDB for example). I've been meaning to run the reported benchmark posted by EnterpriseDB myself, but haven't yet had the chance. My other concern with that benchmark is that it really doesn't cover much in the way of an interesting workload.
I used 100 elements per document since I plan on benchmarking support for parallel array indexes using two array fields with 10 elements each.