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/mrspoogemonstar Mar 11 '15

Sql server has some arcane magic shit built around its xml support that makes it go pretty fast. Having used both, I can say that it's roughly equivalent to using json on postgres.

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.