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

Learn how to troubleshoot and diagnose some of the most common performance issues in Java today. Brought to you in partnership with AppDynamics.

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.

Understand the needs and benefits around implementing the right monitoring solution for a growing containerized market. Brought to you in partnership with AppDynamics.


Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

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 }}