Re:PostgreSQL Outperforms MongoDB in New Round of Tests
by tmcallaghan 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.
Re:PostgreSQL Outperforms MongoDB in New Round of Tests
by RyanZAG on Saturday September 27, 2014 @03:37AM
(#8376370)
Going off [1] it looks like TokuMX is a similar multiple faster than Mongo than Postgre is from Mongo, so I'd guess Postgre and Toku would be fairly similar speed wise. Obviously depending on your data and search patterns one may still be significantly faster than the other as the usual caveat.
[1] http://www.databasejournal.com/sqletc/tokumx-compared-to-mon...
I am a huge fan of PostgreSQL, but in order to avoid having to rewrite an application designed for Mongo, I tried TokuMX and was pleasantly surprised by its performance.