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

Postgres Weekly 143   . 

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

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

[Migrating Postgres to Amazon RDS Without Downtime](https://www.theguardian.com/info/developer-blog/2016/feb/04/migrating-postgres-to-rds-without-downtime?utm_source=postgresweekly&utm_medium=email)The maturity of database-as-a-service providers has improved a lot. Whether [Heroku Postgres](https://www.heroku.com/postgres) or [Amazon RDS](https://aws.amazon.com/rds/postgresql/), there are now fewer reasons to manage your own. Here’s a guide on how The Guardian migrated with no downtime from their own hosted instance to RDS. The Guardian [Performance Tuning Queries in PostgreSQL](http://www.geekytidbits.com/performance-tuning-postgres/?utm_source=postgresweekly&utm_medium=email)Database performance tuning still remains a magical art for many developers, but this post walks through everything you need to know to get started assessing and improving queries. Brady Holt [Finally, 100TB PostgreSQL Data Warehouse Has Arrived](http://vitessedata.com/vitesse-db)Vitesse DB Enterprise Edition is PostgreSQL for OLAP/BI enhanced with builtin multi-threading, LLVM JIT and compressed column store. Find out how this PostgreSQL solution for Data Warehouse or Data Mart can work for you. Vitesse Data#sponsored[![\](https://copm.s3.amazonaws.com/e5c9f75e.png)](http://vitessedata.com/vitesse-db) [Creating a Document-Store Hybrid in Postgres 9.5](https://blog.andyet.com/2016/02/04/postgres-9.5-document-store-hybrid/?utm_source=postgresweekly&utm_medium=email)We’ve linked to a few ‘Postgres as a Document Store using JSONB’ posts. Here’s another that takes it one step further and converts some of those documents back to normalized data. Nathan Fritz [Explaining the Postgres Query Optimizer [video\]](https://www.youtube.com/watch?v=svqQzYFBPIo&utm_source=postgresweekly&utm_medium=email) Bruce Momjian#video [PostgreSQL Logical Decoding](http://www.slideshare.net/8kdata/postgresql-logical-decoding?utm_source=postgresweekly&utm_medium=email)Logical decoding has laid some great groundwork for things you can do with Postgres. This deck from Postgres Open walks through what logical decoding is and some example uses of it. Álvaro Hernández [go-dberror: Parsing Postgres Errors in Go](https://github.com/Shyp/go-dberror?utm_source=postgresweekly&utm_medium=email)Postgres’s error messages aren’t always as intelligible as they could be. Here’s a convenient Go package to help you make sense of some of them. Shyp#code [Records: SQL for Humans (in Python)](https://github.com/kennethreitz/records?utm_source=postgresweekly&utm_medium=email)If you’re using a framework you likely already have an ORM. If you’re using more a more direct approach in Python, however, this package aims to make working with Postgres directly simpler. Kenneth Reitz#code [Building Full Text Search For Your App with Postgres](http://www.adalyz.com/building-full-text-search-for-your-application-using-postgres/?utm_source=postgresweekly&utm_medium=email)Most people jump to Elasticsearch or Solr for advanced search cases, yet Postgres can do a fine job of it itself. Adailyz [PostgreSQL Developers, Consultants & Support DBAs at 2ndQuadrant](http://2ndquadrant.com/en/about/careers/?utm_source=postgresweekly&utm_medium=email)We're in demand ....and that means you could be too! Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. [Check out our vacancies.](http://2ndquadrant.com/en/about/careers/) 2ndQuadrant#job [Postgres Skills are in demand](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres)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.](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres) Indeed.​com#job    

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