---
title: "This Week's PostgreSQL News (#142)"
publication: "Postgres Weekly"
issue: 142
published_at: "2016-02-03"
canonical_url: "https://postgresweekly.com/issues/142"
---

Postgres Weekly 142   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 142 — February 3, 2016     

[Using PostgreSQL in R: A Quick How-To](http://www.win-vector.com/blog/2016/02/using-postgresql-in-r/?utm_source=postgresweekly&utm_medium=email)R is a great language when it comes to analytics, and Postgres is great for storing your data. Fortunately, both of them can work well together and here’s your quick guide. Nina Zumel [Postgres 9.5: Three Little Things](http://blog.endpoint.com/2016/01/postgres-95-three-little-things.html?utm_source=postgresweekly&utm_medium=email)There have been some great posts about [Postgres 9.5’s main features](http://www.craigkerstiens.com/2015/12/27/postgres-9-5-feature-rundown/) but there are some smaller items that make a difference - here’s three you may have missed. Greg Sabino Mullane [Breaking News: New Enterprise-Ready EDB Postgres Advanced Server 9.5](http://www.enterprisedb.com/news-events/press-releases/enterprisedb-announces-availability-edb-postgres-advanced-server-95-and-e?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016EPAS95)Newly released EDB Postgres Advanced Server 9.5 features a range of enhancements for increased performance, scalability, security, and manageability to ensure success with Postgres for business critical workloads. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/edf5bf63.png)](http://www.enterprisedb.com/news-events/press-releases/enterprisedb-announces-availability-edb-postgres-advanced-server-95-and-e?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016EPAS95) [Waiting for 9.6 – Support Parallel Joins](http://www.depesz.com/2016/02/01/waiting-for-9-6-support-parallel-joins-and-make-related-improvements/?utm_source=postgresweekly&utm_medium=email)Postgres 9.5 is here, which means we can now look forward to Postgres 9.6. While it’s still early days, parallel joins will undoubtedly be one of the major highlights, and these could deliver some great performance improvements. Hubert depesz Lubaczewski [Always Put 'stats_temp_directory' on a Memory-Based File System](http://thebuild.com/blog/2016/02/02/always-do-this-4-put-stats_temp_directory-on-a-memory-file-system/?utm_source=postgresweekly&utm_medium=email)The Postgres stats collector generates a lot of write activity so this will help with overall system IO performance. The Build [ML-Based Prediction with PostgreSQL and PL/R in Four Rounds](http://theplateisbad.blogspot.com/2016/01/ml-based-prediction-with-postgresql-plr.html?utm_source=postgresweekly&utm_medium=email)Integrating with R seems to be the hot thing for Postgres right now. Here’s our second post for the week looking at Postgres and R, this time with more advanced machine learning tied to it. Ergo [Fast Fuzzy Text Search In Phoenix With Ecto](https://github.com/cometaworks/fast_fuzzy_search_in_phoenix_and_ecto?utm_source=postgresweekly&utm_medium=email)A tutorial on introducing a very fast fuzzy text search in Postgres using Phoenix and Ecto. CometaWorks#code [Binomial Options Pricing in SQL](https://www.periscopedata.com/blog/binomial-options-pricing-in-postgres.html?utm_source=postgresweekly&utm_medium=email)How to set up a discrete binomial tree using the binomial options pricing model to value derivatives in SQL, and apply this in an example of pricing a 3-period call option. Periscope#tutorial [How To Back Up, Restore, and Migrate PostgreSQL Databases with Barman on CentOS 7](https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7?utm_source=postgresweekly&utm_medium=email) Sadequl Hussain#tutorial [Postgres Skills are in demand.](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres&utm_source=postgresweekly&utm_medium=email)Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today! Indeed#job    

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