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

Postgres Weekly 177   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 177 — October 5, 2016     

[6 Reasons to Choose PostgreSQL 9.6](http://blog.taadeem.net///english/2016/10/01/6_reasons_to_choose_PostgreSQL_9.6?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 is finally here! Here’s a rundown of 6 reasons you should take a look at it or consider upgrading. Damien Clochard#opinion [pgAdmin 4 v1.0 Released](https://www.pgadmin.org/?utm_source=postgresweekly&utm_medium=email)The open source management and administration tool for Postgres has been completely rewritten using Python and JavaScript. PostgreSQL#tools [Designing your SaaS Database for Scale with Postgres](https://www.citusdata.com/blog/2016/10/03/designing-your-saas-database-for-high-scalability/?utm_source=postgresweekly&utm_medium=email)Different applications have different design trade-offs, here’s a rundown of the options for a B2B SaaS application and the things you need to keep in mind. Citus Data [PostgreSQL 9.1 has reached EOL, need to upgrade?](https://2ndquadrant.com/en/services/upgrade-postgresql/)PostgreSQL 9.1 has reached its End-Of-Life and we recommend upgrading to a newer version of PostgreSQL. Schedule your almost zero downtime upgrade today and take advantage of 2ndQuadrant's team of experts to ensure a smooth transition. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/9991fcee.png)](https://2ndquadrant.com/en/services/upgrade-postgresql/) [Using PostgreSQL Full Text Search with Go](https://www.opsdash.com/blog/postgres-full-text-search-golang.html?utm_source=postgresweekly&utm_medium=email)Postgres full-text search is built in and for many cases can go quite far. Here’s a primer on how to get started on FTS and Postgres in Go. RapidLoop#tutorial [Pairing LLVM JIT with Postgres Can Speed Up Database Performance](http://www.phoronix.com/scan.php?page=news_item&px=LLVM-JIT-PostgreSQL&utm_source=postgresweekly&utm_medium=email)LLVM JIT is used for just-in-time compilation of queries. Dmitry Melnik#video [Yandex Mail's MySQL to Postgres Success Story](https://www.youtube.com/watch?v=-SS4R1sFH3c&utm_source=postgresweekly&utm_medium=email)Yandex recently completed one of the larger migrations from MySQL to Postgres. Here’s a 45 minute talk on how they accomplished it. YouTube#video [pgmigrate: Simple Tool to Evolve PostgreSQL Schemas Easily](https://github.com/yandex/pgmigrate?utm_source=postgresweekly&utm_medium=email)Yandex just completed one of the larger Postgres migrations from MySQL and have now open sourced their tool to make it easier to evolve. Yandex#code [ZSON: A PostgreSQL Extension for Transparent JSONB Compression](https://github.com/afiskon/zson?utm_source=postgresweekly&utm_medium=email)For certain workloads ZSON could greatly reduce your disk footprint while still providing higher throughput. Aleksander Alekseev#code [PgHero: A Performance Dashboard for Postgres](https://github.com/ankane/pghero?utm_source=postgresweekly&utm_medium=email) Andrew Kane#code [Don't Get Frustrated Job Hunting - Get Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Sick of pushy recruiters, and dead end interviews? Try Hired to hear from top tier companies, and only talk to relevant companies. Hired#sponsored    

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