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

Postgres Weekly 149   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 149 — March 23, 2016     

[These Are a Few of My Favorite (psql) Things](http://blog.thefourthparty.com/these-are-a-few-of-my-favorite-psql-things/?utm_source=postgresweekly&utm_medium=email)It’s not much of a secret I love [psql](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/), the command line based utility for interacting with Postgres. If you think you need a graphical editor, though, first try exploring all psql has to offer. Lauren Ellsworth [Join the Postgres Community on Slack](https://postgres-slack.herokuapp.com/?utm_source=postgresweekly&utm_medium=email)Love Postgres? Can’t wait each week to get your regular fix? Or just have an issue you want some input on? Join the Postgres Slack live chat group and join others in conversation around all things Postgres. Postgres Slack [Scan and aggregate 81 GB table in 5 seconds!](http://vitessedata.com/vitesse-db)Vitesse DB Enterprise Edition is PostgreSQL enhanced with built-in multi-threading, LLVM JIT and compressed column store. Check out the TPC-H 100 numbers, and discover why PostgreSQL is ready for reporting and data warehouse. Vitesse Data#sponsored[![\](https://copm.s3.amazonaws.com/2a22e4af.png)](http://vitessedata.com/vitesse-db) [Parallel Aggregation Support for Postgres 9.6](http://www.postgresql.org/message-id/flat/E1ahzxY-0004qA-GJ@gemulon.postgresql.org?utm_source=postgresweekly&utm_medium=email#E1ahzxY-0004qA-GJ@gemulon.postgresql.org)Up until now Postgres on a single node only couldn’t take advantage of parallelism. Postgres 9.6 is starting to shape up as the release to improve that. Robert Haas#news [PostgreSQL Upsert; A Few Bad Apples](http://coderedux.com/on-postgresql/upsert-bad-apples?utm_source=postgresweekly&utm_medium=email)A look at some real-world problems a developer ran into when using the new ‘upsert’ functionality in Postgres. David Toomey [Approaches to High Availability for Postgres [PDF\]](http://thebuild.com/presentations/pgha-fosdem-2016.pdf?utm_source=postgresweekly&utm_medium=email)You want to be up 24/7 - part of that is having your database up too. When it comes to high availability there’s no shortage of options but they all have tradeoffs. Take a look at a rundown of pros and cons of various approaches here. Christophe Pettus [Fast Search Using PostgreSQL Trigram Indexes](https://about.gitlab.com/2016/03/18/fast-search-using-postgresql-trigram-indexes/?utm_source=postgresweekly&utm_medium=email)When you want to have free form search on text, _full-text search_ is usually the solution. Postgres has powerful built-in search features, and GitLab highlights here how they used it to improve the experience of their service. Yorick Peterse#tutorial [Troubleshooting Waits in PostgreSQL](http://amitkapila16.blogspot.co.uk/2016/03/troubleshooting-waits-in-postgresql.html?utm_source=postgresweekly&utm_medium=email) Amit Kapila#tutorial [Understanding Distributed Postgres BDR](https://chrismeyersfsu.wordpress.com/2016/03/20/understanding-distributed-postgres-bdr/?utm_source=postgresweekly&utm_medium=email)A slide presentation on Postgres BDR, which continues to be in the works. You’ll find background information necessary to understand different Postgres Distributed modes of operation and a high-level of what BDR is. Chris Meyers#opinion [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=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/149) [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