Re:PgREST: Node.js in the Database, compatible with MongoLab...
by recuter on Friday November 29, 2013 @08:17AM
(#6819274)
We added performance comparison with MongoDB. MongoDB is very slow on loading data (slide 59) - 8 minutes vs 76s,
seqscan speed is the same - about 1s, index scan is very fast - 1ms vs 17 ms with GIN fast-scan patch. But we managed to create new opclass (slides 61-62) for hstore using hashing of full-paths concatenated with values and got 0.6ms, which is faster than mongodb !
It's worth noticing, that MongoDB index is very "narrow" index, while hstore's indexes could speedup more queries.
====
Well, wow. This is 6-12 months away, and really exciting.
It's worth noticing, that MongoDB index is very "narrow" index, while hstore's indexes could speedup more queries.
====
Well, wow. This is 6-12 months away, and really exciting.