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

Postgres Weekly 151   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 151 — April 6, 2016     

[PostgreSQL: 2016-03-31 Security Update Release](http://www.postgresql.org/about/news/1656/?utm_source=postgresweekly&utm_medium=email)Point releases are here for all the latest versions of Postgres. While the security issues here could be a lot worse, it’s still encouraged to upgrade when you’re able to. postgresql.​org [Postgres 9.6 Feature Highlight: Read Balancing with remote_apply](http://michael.otacoo.com/postgresql-2/postgres-9-6-feature-highlight-remote-apply/?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 features are mostly set at this point, but this is a new one that just made it in. A new level of synchronous commit, ‘remote_apply’, will make easier some guarantees on the read consistent side when used. Michael Paquier#news [Five Ways to Paginate in Postgres, From The Basic to The Exotic](https://www.citusdata.com/blog/1872-joe-nelson/409-five-ways-paginate-postgres-basic-exotic?utm_source=postgresweekly&utm_medium=email)This article examines several methods of server-side pagination and discusses their tradeoffs when implemented in PostgreSQL. Joe Nelson#tutorial [PostgreSQL and per-connection write consistency settings](https://www.compose.io/articles/postgresql-and-per-connection-write-consistency-settings/?utm_source=cooper&utm_medium=banner&utm_campaign=postgresweekly)When it comes to consistent performance, PostgreSQL has some good, predictable defaults. But there are tradeoffs between performance, consistency and outages. In this article we examine the tradeoffs and discuss per-connection tunable write consistency over a cluster. Compose#sponsored[![\](https://copm.s3.amazonaws.com/5b98b80d.png)](https://www.compose.io/articles/postgresql-and-per-connection-write-consistency-settings/?utm_source=cooper&utm_medium=banner&utm_campaign=postgresweekly) [ETL Journey from Oracle to Postgres](http://engineering.pivotal.io/post/etl-journey-from-oracle-to-postgres/?utm_source=postgresweekly&utm_medium=email)We’ve covered a number of articles about migrating [from MySQL](http://tapoueh.org/blog/2013/08/08-MySQL-to-PostgreSQL.html) or [MongoDB](https://www.amberbit.com/blog/2015/11/30/using-repository-pattern-to-migrate-rails-app-from-mongodb-to-postgresql/) to Postgres. Here’s one we haven’t seen as much of - moving from Oracle to Postgres. Pivotal Engineering Journal [PostgreSQL Conference US is in 2 Weeks](http://www.pgconf.us/2016/?utm_source=postgresweekly&utm_medium=email)Join the rest of the community at one of its biggest conferences in NYC - April 18-20. PGConf US#news [Parallel Sequential Scan Support in Postgres](http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=989be0810dffd08b54e1caecec0677608211c339&utm_source=postgresweekly&utm_medium=email)A commit to the Postgres codebase that “extends synchronous replication so that it supports multiple synchronous standby servers.” postgresql.​org#news [A Tour of PostgREST](http://begriffs.com/posts/2016-03-20-postgrest-tour.html?utm_source=postgresweekly&utm_medium=email)PostgREST is a tool for giving you a good, clean and powerful Postgres-driven API out of the box. This video walks you through its functionality and features. Joe Nelson#video [PostgreSQL Bloat: Origins, Monitoring and Managing](https://www.compose.io/articles/postgresql-bloat-origins-monitoring-and-managing/?utm_source=postgresweekly&utm_medium=email)A look at the wider aspects of monitoring and managing the ‘bloat’ in PostgreSQL that’s a consequence of its MVCC model. Robert M.​ Wysocki#opinion [Event: An Introduction to PostgreSQL (London, April 13)](https://www.eventbrite.co.uk/e/an-introduction-to-postgresql-tickets-22699033420?utm_source=postgresweekly&utm_medium=email)A free seminar taking place in London, led by Simon Riggs. 2ndQuadrant#news [pg_tmp: Run Tests On An Isolated, Temporary Postgres Database](http://ephemeralpg.org/?utm_source=postgresweekly&utm_medium=email) Eric Radman#tools [pg_recall: An Extension That Tracks Changes to Tables](https://github.com/mreithub/pg_recall/?utm_source=postgresweekly&utm_medium=email)Keeps track of changes in a separate _log table (one _log table for each managed data table). Manuel Reithuber#tools [Monitoring Wait Events in PostgreSQL 9.6](http://akorotkov.github.io/blog/2016/03/25/wait_monitoring_9_6/?utm_source=postgresweekly&utm_medium=email)A look at pg_wait_sampling which automates gathering sampling statistics of wait events. Alexander Korotkov#tools [PostgreSQL Health Check - Get Your Database Checked By Our Experts](http://2ndquadrant.com/postgresql-healthcheck/)A comprehensive audit of your database architecture to improve performance, uptime, security and recoverability. 2ndQuadrant#sponsored    

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