# My wishlist for Postgres 9.5

DevFeed: [My wishlist for Postgres 9.5](<https://devfeed.tech/articles/my-wishlist-for-postgres-9-5-41173.md>)

Original publisher: [Read original article](<https://www.craigkerstiens.com/2014/08/15/My-wishlist-for-Postgres-9.5/>)

Author: Map

Published: 2014-08-15T20:55:56Z

Content type: opinion

Language: en

Sources: [Craig Kerstiens](<https://devfeed.tech/sources/craig-kerstiens.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [releases](<https://devfeed.tech/topics/releases.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [postgres](<https://devfeed.tech/tags/postgres.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [race-condition](<https://devfeed.tech/tags/race-condition.md>), [releases](<https://devfeed.tech/tags/releases.md>), [replication](<https://devfeed.tech/tags/replication.md>)

## AI overview

An opinionated wishlist for PostgreSQL 9.5 covering upsert support, Foreign Data Wrappers, statistics and analytics, multi-master and logical replication, and an official GUI.

## Source excerpt

As I followed along with the 9.4 release of Postgres I had a few posts of things that I was excited about, some things that missed, and a bit of a wrap-up. I thought this year (year in the sense of PG releases) I'd jump the gun and lay out areas I'd love to see addressed in PostgreSQL 9.5. And here it goes: Upsert 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. Foreign Data Wrappers There's so much opportunity here, and this has easily been my favorite feature of the past 2-3 years in Postgres. Really any improvement is good here, but a hit list of a few valuable things: Pushdown of conditions Ability to accept a DSN to a utility function to create foreign user and tables. Better security around creds of foreign tables More out of the box FDWs Stats/Analytics Today there's madlib for machine learning, and 9.4 got support for ordered set aggregates, but even still Postgres needs to keep moving forward here. PL-R and PL-Python can help a good bit as well, but having more out of the box functions for stats can continue to keep it at the front of the pack for a database that's not only safe for your data, but powerful to do analysis with. Multi-master This is definitely more of a dream than not. Full multi-master replication would be amazing, and it's getting closer to possible. The sad truth is even once it lands it will probably require a year of maturing, so even more reason for it to hopefully hit in 9.5 Logical Replication The foundation made it in for 9.4 which is huge. This means we'll probably see a good working out of the box logical replicat