Postgres Weekly 165

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.

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.

Modeling Polymorphic Associations in a Relational Database

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.

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.

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.

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.

The next in a series of posts on Postgres’s fault tolerance capabilities - this time looking at replication and its relevance to fault tolerance.

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.

From time to time we need to investigate if there is any query running indefinitely on a PostgreSQL database.

Built on top of Heroku Postgres, postgression is a service for temporarily spinning up a Postgres database for testing purposes only.

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.