Postgres 9.4 feature highlight: Indexing JSON data with jsonb data type

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by tracker1 on Monday November 17, 2014 @02:48AM (#8617249)

Now if only I had a baked in solution for a replica set, with hot master failover and command forwarding in PostgreSQL like I get with MongoDB.

Quirky bolt-on solutions, and those requiring a contract with EnterpriseDB or others need not apply.

I really don't mean for this to be as snarky as it sounds... I'd really love these features in PostgreSQL along with PLv8, I'd rather use that than MongoDB... unfortunately having a good in the box solution for MongoDB over PostgreSQL is a bigger breaking point than lack of Joins in my use case.

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by moe on Monday November 17, 2014 @06:42AM (#8617759)

with hot master failover and command forwarding [...] like I get with MongoDB.

Failover is documented to not work very well in MongoDB (data loss): http://aphyr.com/posts/284-call-me-maybe-mongodb

On the postgres side RepMgr makes dealing with replication quite easy: https://github.com/2ndQuadrant/repmgr

See also this recent thread on the PostgreSQL mailing list: http://postgresql.nabble.com/Fully-automatic-streaming-repli...

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by Xylakant on Monday November 17, 2014 @11:08AM (#8618773)

I'd be careful quoting the aphyr post in that context. PG also had some failures, even in the non-replicated setup: http://aphyr.com/posts/282-call-me-maybe-postgres

Failures are just a property of distributed systems, some fail in ways that are better for you, some fail in ways that are worse, but sooner or later they all fail. It's a tradeoff which one you choose.

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by moe on Monday November 17, 2014 @11:57AM (#8619051)

PG also had some failures

MongoDB loses acknowledged writes in its supposed "highest consistency" mode.

PostgreSQL does not.

That's a pretty fundamental difference, don't you think?

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by Xylakant on Monday November 17, 2014 @01:06PM (#8619456)

MongoDB was tested in a replicated setup, PG not, that's a pretty fundamental difference. Loosing acked writes in a master-slave replication with failover would be expected with a sufficiently large replication lag even for PG.

MongoDB is about the last database I'd pick for any given scenario, but I acknowledge that there are people that have a usecase where it might be a good fit because the tradeoffs work out for them.

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by moe on Tuesday November 18, 2014 @06:41AM (#8623467)

Loosing acked writes in a master-slave replication with failover would be expected with a sufficiently large replication lag even for PG.

Bullshit.

[ Parent | on HN ]

Re:Postgres 9.4 feature highlight: Indexing JSON data with j... by eknkc on Monday November 17, 2014 @05:29AM (#8617609)

Same here, we use MongoDB with 3 member replica sets even for small deployments. It's easy, built in, works fine with all official drivers.

I'd love to use PostgreSQL but we don't have resources to manage a decent replica set installation with all the sysop burden..

[ Parent | on HN ]