---
title: "This Week's PostgreSQL News (#113)"
publication: "Postgres Weekly"
issue: 113
published_at: "2015-07-08"
canonical_url: "https://postgresweekly.com/issues/113"
---

Postgres Weekly 113   . 

[Read this on the Web](http://postgresweekly.com/issues/113) 

[Postgres Weekly](http://postgresweekly.com) Issue 113 — July 8, 2015     

[PostgreSQL 9.5 Alpha 1 Released](http://www.postgresql.org/about/news/1595/?utm_source=postgresweekly&utm_medium=email)This release contains previews of all of the features which will be available in the final release of version 9.5 (e.g. Block-Range Indexes, UPSERT, Row-Level Security). Postgresql.​org#news [Test PostgreSQL 9.5 Alpha in a Docker container](http://www.databasesoup.com/2015/07/test-postgresql-95-alpha-in-docker.html?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 is around the corner and if you don’t want to wait until it’s fully released to start playing here’s a Docker container to get you up and running with it. databasesoup.​com [Slow PostgreSQL Performance? Don't Forget to Vacuum your Database](https://lob.com/blog/supercharge-your-postgresql-performance/?utm_source=postgresweekly&utm_medium=email)Under the covers Postgres is a giant append only log. This means even when you delete it’s still there, though it does come back through and clean up. Generally this works fine out of the box, but sometimes on large and busy tables you need to do a little yourself. Marcus Gartner [Time for a Database Checkup?](http://www.enterprisedb.com/ahc?utm_source=cooperpress&utm_medium=nl&utm_campaign=tahc)Over time, conditions change including data growth, usage patterns, and the amount of resources available to the database. Periodic tuning is part of Postgres DBAs role to ensure that things continue to run smoothly. Learn how to [optimize performance](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafUAAQ?utm_source=cooperpress&utm_medium=nl&utm_campaign=bperf) or get help with a [database check up](http://www.enterprisedb.com/ahc?utm_source=cooperpress&utm_medium=nl&utm_campaign=bahc). EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/7416decc.png)](http://www.enterprisedb.com/ahc?utm_source=cooperpress&utm_medium=nl&utm_campaign=tahc) [How About Hypothetical Indexes?](https://rjuju.github.io/postgresql/2015/07/02/how-about-hypothetical-indexes.html?utm_source=postgresweekly&utm_medium=email)Hypothetical indexes we featured last week. If you haven’t given it a spin yet then you can get a deeper run down of how the extension works and the features that are available with it. Julien Rouhaud#code [PipelineDB: The Streaming SQL Database](http://www.pipelinedb.com/?utm_source=postgresweekly&utm_medium=email)An open-source relational database (based on PostgreSQL 9.4) that runs SQL queries continuously on streams, incrementally storing results in tables. PipelineDB [Beyond Upsert - Coming in PostgreSQL 9.5](https://www.compose.io/articles/coming-in-postgresql-9-5/?utm_source=postgresweekly&utm_medium=email)Yes, we all know upsert is coming to Postgres 9.5, but that’s not all that’s included. Check out a rundown of a few of the other top features that we can expect with the next release. DJ Walker-Morgan [Postgres 9.5 Feature Highlight: New JSONB Functions and Operators](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-new-jsonb-functions/?utm_source=postgresweekly&utm_medium=email)If you’re curious to dive even deeper on the features in Postgres 9.5 than just beyond the high level here’s your run through of the improvements to JSONB. These new functions and operators continue to make Postgres and JSON as powerful as ever. Michael Paquier [100x Faster Postgres Performance by Changing 1 Line (2013)](http://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/?utm_source=postgresweekly&utm_medium=email)In a specific sort of query, that is. Datadog#tutorial [Freelance with Companies like Airbnb, IDEO, JPMorgan](http://www.toptal.com/developers?utm_source=postgresweekly&utm_medium=email&utm_campaign=postgres_weekly_job)Work with top clients, set your own rates, and work from anywhere as an elite Toptal developer. Join the most exclusive network of top software engineers in the world. Toptal#job    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/113) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK