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

Postgres Weekly 157   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 157 — May 18, 2016     

[Postgres 9.6 Beta 1 Released](http://www.postgresql.org/docs/devel/static/release-9-6.html?utm_source=postgresweekly&utm_medium=email)The first beta of Postgres 9.6, which features parallel scans and joins, is here. Whether you’re looking to try out the new features or just test for bugs and quality issues, give it a try today. postgresql.​org#news [Understanding Caching in Postgres - An In-Depth Guide](http://madusudanan.com/blog/understanding-postgres-caching-in-depth?utm_source=postgresweekly&utm_medium=email)Postgres is quite intelligent about keeping your frequently accessed data cached. If you’re not already convinced of that, give this a read and appreciate all that Postgres does for you. Madusudanan#tutorial [Instant APIs for Postgres](https://www.dreamfactory.com/signup/instant-api-for-postgresql?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=instant)DreamFactory auto-generates APIs and enables data and service bundling across multiple servers and DBs. Supports V8js, Node.js, PHP, and Python for custom scripting. DreamFactory#sponsored[![\](https://copm.s3.amazonaws.com/b0168a68.png)](https://www.dreamfactory.com/signup/instant-api-for-postgresql?utm_source=postgres_weekly&utm_medium=newsletter&utm_campaign=instant) [PostgreSQL 9.5.3, 9.4.8, 9.3.13, 9.2.17 and 9.1.22 Released](http://www.postgresql.org/about/news/1669/?utm_source=postgresweekly&utm_medium=email)This release fixes issues reported over the last two months. You should plan to upgrade at the next available downtime, unless you’ve been affected directly by the fixed issues. postgresql.​org#news [How to Add A New Keyword to SQL's Grammar in Postgres](http://shaplov.livejournal.com/903924.html?utm_source=postgresweekly&utm_medium=email)A simple example of some low-level hacking on the Postgres source code. Svami Dhyan Nataraj#tutorial [pgsync: Sync Postgres Data to Your Local Machine](https://github.com/ankane/pgsync?utm_source=postgresweekly&utm_medium=email)Pgsync is a handy utility inspired by Heroku’s pgtransfer for copying data from your production DB to a local instance. It also includes some handy functionality for cleansing data. Andrew Kane#code [PLV8 Binaries for Postgres 9.6beta1 on Windows](http://www.postgresonline.com/journal/archives/367-PLV8-binaries-for-PostgreSQL-9.6beta1-windows-both-32-bit-and-64-bit.html?utm_source=postgresweekly&utm_medium=email)Extensions, for many, are as important as the core of Postgres. Here almost immediately after the Postgres 9.6 beta release we have support for PLV8 - the V8 engine as a procedural language directly in Postgres… Yes, JavaScript in your Postgres. Leo Hsu and Regina Obe [PGConf Silicon Valley - Call for Papers Open](http://www.pgconfsv.com/call-papers?utm_source=postgresweekly&utm_medium=email)PG Conf Silicon Valley is happening again this year in November so save the dates (Nov 14-16). If you have something interesting to say about Postgres, they’d love to hear from you. PGConf Silicon Valley PostgreSQL Conference [Building A Better Community: The Unsung Heroes Collection](https://www.postgresql.us/building_a_better_community_part_one_unsung_heroes_0?utm_source=postgresweekly&utm_medium=email)While only a small number of people are core committers, there’s a broader set of people benefiting Postgres who you may not know. In the first unsung hero award take a look at how David G. Johnston helps contribute and some of his views. United States PostgreSQL Association [Multi Master Replication for PostgreSQL](http://2ndquadrant.com/en/resources/bdr/)Need to deploy geographically distributed multi-master PostgreSQL clusters? Try Bi-Directional Replication (BDR) for free. 2ndQuadrant#sponsored    

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