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

Postgres Weekly 165   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 165 — July 13, 2016     

[Faster PostgreSQL Searches with Trigrams](http://blog.scoutapp.com/articles/2016/07/12/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity?utm_source=postgresweekly&utm_medium=email)pg_trgm is a PostgreSQL extension providing simple fuzzy string matching which, in some circumstances, can be a lot faster to use than full-text search. Greg Navis#tutorial [Parallel Sequential Scan in PostgreSQL 9.6](http://blog.2ndquadrant.com/postgresql96-parallel-sequential-scan/?utm_source=postgresweekly&utm_medium=email)9.6 is feature frozen and due to arrive later this year. A major step forward has been the laying of a foundation for improved parallelism with sequential scan support. Francesco Canovai [Modeling Polymorphic Associations in a Relational Database](https://hashrocket.com/blog/posts/modeling-polymorphic-associations-in-a-relational-database?utm_source=postgresweekly&utm_medium=email)Polymorphic associations can be difficult to correctly represent in a relational database. This post compares four different ways to model these challenging relationships. Jack Christensen [Calculating a Moving Average in PostgreSQL](https://www.compose.com/articles/metrics-maven-calculating-a-moving-average-in-postgresql/?utm_source=cooper&utm_medium=postgresql-newsletter&utm_campaign=postgres-moving-average)Moving averages make it easier to spot trends in your metrics and smooth out dips and spikes in data. In this article, we show how to calculate moving averages by taking advantage of windowing features. Compose#sponsored[![\](https://copm.s3.amazonaws.com/78c906ae.png)](https://www.compose.com/articles/metrics-maven-calculating-a-moving-average-in-postgresql/?utm_source=cooper&utm_medium=postgresql-newsletter&utm_campaign=postgres-moving-average) [Citus Cloud Now Generally Available](https://www.citusdata.com/blog/2016/07/13/citus-cloud-ga/?utm_source=postgresweekly&utm_medium=email)Citus Cloud, a managed hosted offering from Citus built on top of AWS, is now generally available. Citus makes it easier to put Postgres into production by offering scaling and processing power to perform analytics over billions of events per day. Citus Data#news [Stateful Database Containers with AWS EFS](https://medium.com/@nzoschke/aws-efs-the-container-friendly-file-system-d5cc1353323e?utm_source=postgresweekly&utm_medium=email)Amazon’s Elastic File System (EFS) is now production ready in 3 AWS regions. This walkthrough looks at running a Postgres container on EFS and what benefits that brings. Noah Zoschke#tutorial [A Beginner's Guide to Thinking in SQL](http://www.sohamkamani.com/blog/2016/07/07/a-beginners-guide-to-sql/?utm_source=postgresweekly&utm_medium=email)At first glance, SQL can look straightforward, but its simple elements can add up to something quite confusing. This primer provides some examples and advice on getting your head around some of SQL’s underlying concepts. Soham Kamani [The Evolution of Fault Tolerance in PostgreSQL: Replication Phase](http://blog.2ndquadrant.com/evolution-of-fault-tolerance-in-postgresql-replication-phase/?utm_source=postgresweekly&utm_medium=email)The next in a series of posts on Postgres’s fault tolerance capabilities - this time looking at replication and its relevance to fault tolerance. Gulcin Yildirim#tutorial [Implementing Full-Text Search in Rails with Postgres](https://www.viget.com/articles/implementing-full-text-search-in-rails-with-postgres?utm_source=postgresweekly&utm_medium=email)Full-text search is among one of the many powerful features in Postgres. Here’s a look at using these features from Ruby on Rails. Ryan Stenberg [Finding and Killing Long Running Queries on PostgreSQL](https://medium.com/little-programming-joys/finding-and-killing-long-running-queries-on-postgres-7c4f0449e86d?utm_source=postgresweekly&utm_medium=email)From time to time we need to investigate if there is any query running indefinitely on a PostgreSQL database. Anderson Dias [postgression: A Postgres Database for Every Test Case](http://www.postgression.com/?utm_source=postgresweekly&utm_medium=email)Built on top of Heroku Postgres, postgression is a service for temporarily spinning up a Postgres database for testing purposes only. Randall Degges#tools [The Easiest Way to Find a Job](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-go&utm_content=easiest&utm_campaign=q3-16-postgresweekly&utm_location=us)Hired lets you sit back while job offers come to you. When you complete your profile, instantly apply to 3,500+ companies on the platform who will contact you with job offers, including salary and equity up-front. [Try it today.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-go&utm_content=easiest&utm_campaign=q3-16-postgresweekly&utm_location=us) Hired.​com#job    

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