A
agent_008_nl
Guest
On the newest indexing / jsonb data-type michael.otacoo.com/.../postgres-9-4-feature-highlight-indexing-jsonb geoffreylitt.com/.../Postgres-BSON.pdf Julio Vassallo posted an interesting reaction to the peg a couple of days ago, here's a copy: ------------------------------------------------------------------------------------------------------------------------- And long before the JSON type, Postgres had the hstore type, a kind of unstructured key-value storage. You could use that type and still do better than MongoDB: thebuild.com/.../pg-as-nosql-pgday-fosdem-2013.pdf At the time of that presentation, the JSON type was little more than a Text type with JSON validation. But Hstore could still give Mongo a run for the money as you can see. Now in the latest Postgres, JSON has special query operators and much better indexing support so it makes a lot more sense to use it. And in 9.4, Postgres is now much faster than MongoDB in all categories and of course it doesn't have the insanely bloated indexes of Mongo: obartunov.livejournal.com/175235.html ----------------------------------------------------------------------------------------------------------------------- Kind regards, Stefan Houtzager Houtzager ICT consultancy & development www.linkedin.com/in/stefanhoutzager
Continue reading...
Continue reading...