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

Postgres Weekly 158   . 

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

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

[Creating Activity Feeds in PostgreSQL 9.5](http://blog.chaps.io/2016/05/18/creating-activity-feeds-in-postgresql.html?utm_source=postgresweekly&utm_medium=email)A look at how to create modern activity feeds with Facebook-like grouping using only Postgres. Piotr Okonski#tutorial [Postgres & Redis Sitting In a Tree](https://speakerdeck.com/neovintage/postgres-and-redis-sitting-in-a-tree?utm_source=postgresweekly&utm_medium=email)“Typically a company may start with a relational database like Postgres and add Redis for more high velocity use-cases. What if you could tie the two together to enable so much more?” Rimas Silkaitis [Changing PostgreSQL Version Numbering](http://www.databasesoup.com/2016/05/changing-postgresql-version-numbering.html?utm_source=postgresweekly&utm_medium=email)The PostgreSQL Project is contemplating a change to how they do version numbers. Josh Berkus#news [EDB Replication Server - 1st production-ready logical replication for PostgreSQL](http://www.enterprisedb.com/postgres-plus-edb-blog/zahid-aqbal/edb-replication-server-first-adopt-faster-wal-based-postgres-repl?src=20160525PGWk_Replica2ndQ)First and only production-ready multi-master replication product to feature new technology developed for PostgreSQL - increasing performance of transactional workloads requiring replication by extracting changes via Write-Ahead Log (WAL) files and reduces latency during replication. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/c5b57d62.png)](http://www.enterprisedb.com/postgres-plus-edb-blog/zahid-aqbal/edb-replication-server-first-adopt-faster-wal-based-postgres-repl?src=20160525PGWk_Replica2ndQ) [Creating Pivot Tables in PostgreSQL Using The Crosstab Function](http://www.vertabelo.com/blog/technical-articles/creating-pivot-tables-in-postgresql-using-the-crosstab-function?utm_source=postgresweekly&utm_medium=email)The ‘tablefunc’ extension provides a really interesting set of functions. One of them is the crosstab function, used for pivot table creation. That’s what this article covers. Maria Alcaraz#tutorial [PostgreSQL Conference Europe 2016 Call for Papers](https://www.postgresql.org/about/news/1670/?utm_source=postgresweekly&utm_medium=email)Now accepting proposals for talks in English. The PostgreSQL Conference Europe is held on November 1-4 in Tallin, Estonia. PostgreSQL#news [Helpful PostgreSQL Logging and Defaults](http://www.openscg.com/2016/05/helpful-postgresql-logging-and-defaults/?utm_source=postgresweekly&utm_medium=email) Scott Mead#tutorial [How to Move From Amazon RDS to A Dedicated PostgreSQL Server](http://layer0.authentise.com/how-to-move-from-amazon-rds-to-dedicated-postgresql-server.html?utm_source=postgresweekly&utm_medium=email) Authentise, Inc#tutorial [Enterprise-class 24/7 PostgreSQL support - for companies of all sizes.](http://2ndquadrant.com/support)Guaranteed response in 15 minutes and a bug fix in 24 hours from 2ndQuadrant - The PostgreSQL Support Company 2ndQuadrant#sponsored [Data Types in PostgreSQL](http://postgres-data-types.pvh.ca/?utm_source=postgresweekly&utm_medium=email#1)A 128 page slidedeck ‘guided tour’ through PostgreSQL data types. Peter van Hardenberg [pg-promise: An Advanced Access Layer to PostgreSQL via Promises](https://github.com/vitaly-t/pg-promise?utm_source=postgresweekly&utm_medium=email) Vitaly Tomilov#code [pgRouting 2.2.3 Released with Support for PostgreSQL 9.6beta1](http://www.bostongis.com/blog/index.php?/archives/255-pgRouting-2.2.3-released-with-support-for-PostgreSQL-9.6beta1.html=&utm_source=postgresweekly&utm_medium=email)Version 2.2.3 of pgRouting was released last week. The main change is support for PostgreSQL 9.6. Regina Obe#news [Apply to 100 top tech companies with 1 application](http://www.indeed.com/prime?kw=postgresweekly&sid=xp_cooperpress_job)Indeed Prime connects top tech talent with top companies in the US. Companies compete to hire devs on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime. Indeed Prime by Indeed.​com#job    

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