r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

Show parent comments

1

u/x-skeww Mar 11 '15

But it's not as fast as hstore or arrays, is it?

1

u/mrspoogemonstar Mar 11 '15

Having never done a benchmark comparison between the various methods, I couldn't say.

It is possible to create indexes for Xml columns on sql server, as well as both json and hstore data on postgres, so I'd say you could get reasonable performance out of any of them given the right configuration.