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

Postgres Weekly 140   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 140 — January 20, 2016     

[PostgreSQL Point-in-Time Recovery: An Unexpected Journey](http://blog.endpoint.com/2016/01/postgresql-point-in-time-recovery.html?utm_source=postgresweekly&utm_medium=email)Sometimes it’s not just when a system goes down that you care about data loss or change, sometimes it can be due to operator error. When that happens there’s a chance you already have the underlying pieces to correct it and if not may want to consider this read. David Christensen [An Introduction to PostgreSQL Physical Storage](http://rachbelaid.com/introduction-to-postgres-physical-storage/?utm_source=postgresweekly&utm_medium=email)This primer covers how your data is actually stored under the covers. It’s not required to know how the internals of data storage actually work to use Postgres, but it may still be helpful and interesting to you. Rachid Belaid [Exclusive from EDB: PostgreSQL 9.5 Training and Certification](http://www.enterprisedb.com/postgresql-95-training-certification?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016pgsql95traincert)EDB, the leader in services for Postgres, is the FIRST and ONLY organization to provide official PostgreSQL 9.5 training courses and Certification exams only weeks after the 9.5 release to the community. Be one of the first to train and certify on PostgreSQL 9.5! EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/4b5bc81c.png)](http://www.enterprisedb.com/postgresql-95-training-certification?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016pgsql95traincert) [Upsert Records with PostgreSQL 9.5](https://hashrocket.com/blog/posts/upsert-records-with-postgresql-9-5?utm_source=postgresweekly&utm_medium=email)One of the first write-ups about upsert that clearly lays out how it can be used with a very practical example. Josh Branchaud [Adding Columns with Default Values to Large Tables in Postgres + Rails](http://engineering.wework.com/data/2015/11/05/add-columns-with-default-values-to-large-tables-in-rails-postgres/?utm_source=postgresweekly&utm_medium=email)For most frameworks it’s common for you to set a default value when you add a new column, the problem is this can cause a full table re-write and hold a lock–read: not good. There’s a few methods to work around this. WeWork Engineering [What Is The Best PostgreSQL GUI Tool?](https://www.reddit.com/r/PostgreSQL/comments/412vsw/what_is_the_best_postgresql_gui_tool/?utm_source=postgresweekly&utm_medium=email) Reddit#opinion [Heroku Data Infrastructure Engineer](https://www.heroku.com/careers/104?utm_source=postgresweekly&utm_medium=email)Join the Heroku Data team and learn about supporting and operating database systems at scale. Heroku#job [Objection.js + PostgreSQL: By The Power of JSON Queries](https://www.vincit.fi/en/blog/by-the-power-of-json-queries/?utm_source=postgresweekly&utm_medium=email)While objection.js has had some support for JSON for a little while now, it now has full docs and guides to get you up and running. It joins Massive.JS as a great option for JSON in Node, while still supporting all the greatness that is Postgres. Mikael Lepistö [Postgres Full-Text Search](http://blog.garage-coding.com/2015/12/18/postgres-fulltext-search.html?utm_source=postgresweekly&utm_medium=email)There are a lot of ways to roll a full text search system (such as with Elasticsearch) but if your data is already in Postgres you may have a good enough solution already sitting right there to use. UpStats [PostgreSQL Streaming Replication Cheatsheet](http://blog.postgresql-consulting.com/2016/01/postgresql-sreaming-replication.html?utm_source=postgresweekly&utm_medium=email) Alexey Lesovsky [PipelineDB Enterprise Now Available](http://www.postgresql.org/about/news/1641/?utm_source=postgresweekly&utm_medium=email)PipelineDB is a Postgres 9.4-based streaming analytics database. postgresql.​org#news [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/140) [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