Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 165 — July 13, 2016
Faster PostgreSQL Searches with Trigrams
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
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
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
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 
Citus Cloud Now Generally Available
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
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
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
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
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
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
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
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.
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.