Check out some of these fabulous features of Postgres 9.5 if you haven't already: http://www.postgresql.org/about/news/1636/
We finally have upsert. Finally have CUBE, ROLLUP and GROUPING SETS (I really wanted these when I was playing around with Retrosheet baseball data). We also have BRIN indexes for indexing large-scale tables. And there's now even a way to interface with...dun dun dun...BIG DATA DATABASES.