---
title: "This Week's PostgreSQL News (#110)"
publication: "Postgres Weekly"
issue: 110
published_at: "2015-06-17"
canonical_url: "https://postgresweekly.com/issues/110"
---

Postgres Weekly 110   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 110 — June 17, 2015     

[Following a SELECT Statement Through Postgres Internals](http://blog.codeship.com/following-a-select-statement-through-postgres-internals/?utm_source=postgresweekly&utm_medium=email)Here’s a continued very deep dive into what happens under the covers of Postgres when you run a select statement. If you’ve ever been curious about the internals of Postgres this is a great primer. Pat Shaughnessy [PostgreSQL 9.4.4, 9.3.9, 9.2.13, 9.1.18 & 9.0.22 Released](http://www.postgresql.org/about/news/1592/?utm_source=postgresweekly&utm_medium=email)“Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and 9.4 with ‘multixact wraparound’, but failed to account for issues doing multixact cleanup during crash recovery. This could cause servers to be unable to restart after a crash. As such, all users of 9.3 and 9.4 should apply this update as soon as possible.” postgresql.​org [How to Stop Worrying and Love Your Postgres Indexes](http://engineering-blog.alphasights.com/how-to-stop-worrying-and-love-the-index/?utm_source=postgresweekly&utm_medium=email)Indexes will help make your applications and queries much faster. Here’s a look both from a high level, as well as some deep dive specifics on different types of indexes and how to take advantage of them to improve performance. Ju Liu [PostgreSQL Training – Foundations and Advanced](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tcombobm7)Bruce Momjian will be teaching foundational and advanced topics needed for successful PostgreSQL administration. Join Bruce and learn from his tips and techniques in this live on-line session in July. 20% off promo code COMB-WEB-01. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/f38fbd6e.jpg)](http://www.enterprisedb.com/store/products/dba-training/01t50000002jwhqAAA?utm_source=cooperpress&utm_medium=nl&utm_campaign=tcombobm7) [A Review of H.J. Schönig’s 'Troubleshooting PostgreSQL' Book](http://www.vertabelo.com/blog/notes-from-the-lab/a-handy-guide-to-solving-postgresql-problems?utm_source=postgresweekly&utm_medium=email) Łukasz Woźniak [faitout: Give Access to Volatile PostgreSQL Databases for Testing](https://github.com/fedora-infra/faitout?utm_source=postgresweekly&utm_medium=email)Generates PostgreSQL databases on the fly for a limited time, allowing people to test their code against an actual PostgreSQL database. Fedora Infrastructure#code [ActiveRecord + PostgreSQL Materialized Views](https://medium.com/@WoloxEngineering/activerecord-postgresql-materialized-views-9a9ef56b5a8d?utm_source=postgresweekly&utm_medium=email)Materialized views can make complex/long-running reports much snappier by actually writing out a table equivalent of the resulting view. With a little bit of manoeuvring you can even have your app directly take advantage of them as highlighted here with ActiveRecord. Wolox Engineering [PgCon 2015 Developer Meeting](https://wiki.postgresql.org/wiki/PgCon_2015_Developer_Meeting?utm_source=postgresweekly&utm_medium=email)PgCon, the annual conference for Postgres hackers, is now underway. Each year there’s a variety of talk and coordination on upcoming parts for Postgres. Take a look at some of the meta issues around release schedules and coordination for year ahead within their meeting notes. postgresql.​org [JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server](https://vividcortex.com/blog/2015/06/02/json-support-postgres-mysql-mongodb-sql-server/?utm_source=postgresweekly&utm_medium=email)JSON has been an exciting topic for a few years now in databases. In large part this is due to the rise of attempting to get more flexibility in the app dev process my not being constrained to a specific schema. Here’s a rundown of the support that’s available across a variety of databases. Vivid Cortex    

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