PostgreSQL 9.4 Released • Hacker News Board

Re: PostgreSQL 9.4 Released

#21

Post by bsg75 » Thu, Dec 18, 2014, 4:21 PM UTC

frost_knight wrote: post #20

gh02t wrote: post #17

Earlier quoted context omitted.

> we'd be in a much better place what code-archaeology is concerned. This sounds like a great setup for a sci-fi novel. 500 years into the future, the infrastructure their distant ancestors coded has begun to fail. Now Biff Miffington, code-archaeologist, must sift through millions of forgotten messages using a mysterious tool remembered only as "git." Its interface is arcane and the remaining messages broken, tainte…

Candy Crush Saga on git? Sounds more like a fantasy novel.

Maybe not once it becomes an ancient relic: https://github.com/Olde-Skuul/doom3do

Re: PostgreSQL 9.4 Released

#22

Post by digitalzombie » Thu, Dec 18, 2014, 4:21 PM UTC

k_sze wrote: post #7

Bye bye MongoDB.

How do you cluster in postgresql? Serious question, my prefer noSQL is cassandra and clustering is pretty easy.

I ask this question every year and postgresql have not deliver this. If there is any, there are hardly any documentation on it.

Re: PostgreSQL 9.4 Released

#23

Post by arthursilva » Thu, Dec 18, 2014, 4:24 PM UTC

atonse wrote: post #11

Great news! I'd love to move over to this from MongoDB for a project that has high uptime requirements. But while I think the JSON will really replace it, does PG have a solution for High Availability (like replica sets) in the works? I'm newer to Postgres so am not sure. Replica Sets are the killer feature for me, more so than just storing JSON documents. I'd appreciate if someone can chime in. I've done some googli…

PG has async/sync/hybrid replication for years already. It's not as tooled as MongoDB but there's some tools like http://www.repmgr.org/ to amend it.

Re: PostgreSQL 9.4 Released

#24

Post by netcraft » Thu, Dec 18, 2014, 4:24 PM UTC

How long till someone creates a library with the mongo api?

Re: PostgreSQL 9.4 Released

#25

Post by photograve » Thu, Dec 18, 2014, 4:24 PM UTC

Anyone has a performance benchmark and/or has experience on the scalability on this version?

Re: PostgreSQL 9.4 Released

#26

Post by dnfehren » Thu, Dec 18, 2014, 4:25 PM UTC

gh02t wrote: post #17

pilif wrote: post #5

Like every year before, the Postgres team has blessed us with an early christmas present. And like every release post before, I'd like to use this opportunity to say thanks to the team for the awesome job they are doing year after year. It's not just the database itself (and that's awesome on its own right), but it's also all the peripheral stuff: The documentation is seriously amazing and very complete, the tools th…

> we'd be in a much better place what code-archaeology is concerned. This sounds like a great setup for a sci-fi novel. 500 years into the future, the infrastructure their distant ancestors coded has begun to fail. Now Biff Miffington, code-archaeologist, must sift through millions of forgotten messages using a mysterious tool remembered only as "git." Its interface is arcane and the remaining messages broken, tainte…

Ken Macleod's books have a some of this kind of stuff in them - people having to maintain old space stations that run Oracle DB's and stuff like that.

Re: PostgreSQL 9.4 Released

#27

Post by icebraining » Thu, Dec 18, 2014, 4:25 PM UTC

digitalzombie wrote: post #22

k_sze wrote: post #7

Bye bye MongoDB.

How do you cluster in postgresql? Serious question, my prefer noSQL is cassandra and clustering is pretty easy. I ask this question every year and postgresql have not deliver this. If there is any, there are hardly any documentation on it.

Postgres-XL, Postgres-XC, pg_shard...

Re: PostgreSQL 9.4 Released

#28

Post by dilap » Thu, Dec 18, 2014, 4:25 PM UTC

bkeroack wrote: post #12

apetresc wrote: post #2

So when can we expect AWS RDS to support it? :)

Not trying to be mean but, why wait? If you're stuck on AWS it's not impossible (though difficult and annoying certainly) to get a decently-performant Postgres instance going. The experience setting it up will lessen the vendor-lock that Amazon has on you (convenience always has a price).

Outside observer: Man, I figure setting up a "decently performing" Postgres instance on AWS would be such a common thing to do that it would either be known to be impossible, or have cookie-cutter instructions, if not a script. How is it that it's "difficult and annoying" still?

Not trolling, genuinely curious :)

Re: PostgreSQL 9.4 Released

#29

Post by en4bz » Thu, Dec 18, 2014, 4:28 PM UTC

atonse wrote: post #11

Great news! I'd love to move over to this from MongoDB for a project that has high uptime requirements. But while I think the JSON will really replace it, does PG have a solution for High Availability (like replica sets) in the works? I'm newer to Postgres so am not sure. Replica Sets are the killer feature for me, more so than just storing JSON documents. I'd appreciate if someone can chime in. I've done some googli…

Did you take a look at Slony-I?

http://slony.info/

Re: PostgreSQL 9.4 Released

#30

Post by agentultra » Thu, Dec 18, 2014, 4:28 PM UTC

digitalzombie wrote: post #22

k_sze wrote: post #7

Bye bye MongoDB.

How do you cluster in postgresql? Serious question, my prefer noSQL is cassandra and clustering is pretty easy. I ask this question every year and postgresql have not deliver this. If there is any, there are hardly any documentation on it.

> In 9.4, Logical Decoding supplies a new API for reading, filtering and manipulating the PostgreSQL replication stream. This interface is the foundation for new replication tools, such as Bi-Directional Replication, which supports the creation of multi-master PostgreSQL clusters. Other improvements in the replication system, such as replication slots and time-delayed replicas, improve management and utility of replica servers.