Over a million developers have joined DZone.

PostgreSQL Wishlists: What Users Want to See in 9.5

DZone's Guide to

PostgreSQL Wishlists: What Users Want to See in 9.5

· Java Zone
Free Resource

Are you joining the containers revolution? Start leveraging container management using Platform9's ultimate guide to Kubernetes deployment.

It wasn't too long ago that we saw the release of PostgreSQL 9.4 Beta 1, but now there's talk of PostgreSQL 9.5 and, in particular, what sorts of changes it ought to bring. Two separate wishlists have been assembled in the last few days - one from Craig Kerstiens on his website, and another from Neil McGuigan on DatabasePatterns.com - each sporting a handful of hopes for 9.5. 

Kerstiens goes into detail on a few ideas. For example, he's looking for:

  • Foreign data wrappers
  • Logical replication
  • An official GUI

Among other things. McGuigan, on the other hand, is a little more sparse - just a quick list of 10 ideal updates. His hopes include:

  • Replication with SQLite over WebSocket
  • Incremental/Differential backup and restore over HTTPS
  • Text Search improvements to be more like Solr

But most interesting is their primary overlap, which took the number one position: Upsert.

Kerstiens says:

Merge/Upsert/Insert or Update whatever you want to call it this is still a huge wart that it doesn’t exist. There’s been a few implementations show up on mailing lists, and to the best of my understanding there’s been debate on if it’s performant enough or that some people would prefer another implementation or I don’t know what other excuse. The short is this really needs to happen, until that time you can always implement it with a CTE which can have a race condition.

And McGuigan keeps it simple:

1. Upsert, as always

Check out the full wishlists from Kerstiens and McGuigan for all the details, and leave a comment if there's anything else you'd like to see in PostgreSQL 9.5.

Using Containers? Read our Kubernetes Comparison eBook to learn the positives and negatives of Kubernetes, Mesos, Docker Swarm and EC2 Container Services.


Opinions expressed by DZone contributors are their own.


Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.


{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}