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

Postgres Weekly 119   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 119 — August 19, 2015     

['Big Data' Features Coming in PostgreSQL 9.5](http://lwn.net/Articles/653411/?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 will be here soon and here’s a rundown of the features that help with dealing with big data and performance. LWN [Codeship Interview: Peter van Hardenberg (Heroku Postgres)](http://blog.codeship.com/an-inside-look-with-codeship-peter-van-hardenberg-founding-developer-of-heroku-postgres/?utm_source=postgresweekly&utm_medium=email)Heroku Postgres is one, if not the largest, fleet of Postgres databases in the world. If you want an inside look at some of the lessons learned and how the team has scaled it to what it is here’s a great behind the scenes look. Amanda Hackwith [Want to work on new projects? Make more money? Try a new stack? Relocate?](https://hired.com/?utm_source=newsletters&utm_medium=postgresweekly&utm_campaign=n-q3_15-petercooperpress&utm_content=options)On Hired, we'll bring the options to you. With over 2,000 pre-screened tech companies in 10 cities in the US UK, you'll be sure to find what you're looking for. Join Hired today. Hired.​com#sponsored[![\](https://copm.s3.amazonaws.com/6ef86532.png)](https://hired.com/?utm_source=newsletters&utm_medium=postgresweekly&utm_campaign=n-q3_15-petercooperpress&utm_content=options) [Estimating Needed Memory for a Sort](https://rjuju.github.io/postgresql/2015/08/18/estimating-needed-memory-for-a-sort.html?utm_source=postgresweekly&utm_medium=email)Some Postgres settings are simple and straight forward, others can have big impact and be harder to know what the perfect setting is such as work_mem. This guide walks through how much memory you use in a sort, and helps you properly set a good work_mem value. Julien Rouhard#code [PostgreSQL Conference Silicon Valley Session List](http://www.pgconfsv.com/?utm_source=postgresweekly&utm_medium=email#!breakout-sessions/csgk)PGConf Silicon Valley is a few months away, so there’s still time to grab your ticket and plan to attend. In case you need extra motivation the list of talks is now live, and they look great. pgconfsv.​com [Approximate counts in Postgres](http://people.planetpostgresql.org/dfetter/index.php?/archives/80-Approximate-Counts.html=&utm_source=postgresweekly&utm_medium=email)Under the covers Postgres has a mechanism of tracking a rough count of the rows in a table, but it includes querying some under the hood catalog tables. Though with this handy function you can now easily query any table for a rough count. David Detter    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/119) [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