---
title: "This Week's PostgreSQL News (#194)"
publication: "Postgres Weekly"
issue: 194
published_at: "2017-02-15"
canonical_url: "https://postgresweekly.com/issues/194"
---

Postgres Weekly 194   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 194 — February 15, 2017     

[PostgreSQL 9.6.2, 9.5.6, 9.4.11, 9.3.16 and 9.2.20 Released](https://www.postgresql.org/about/news/1733/?utm_source=postgresweekly&utm_medium=email)This group release includes fixes that prevent data corruption issues in index builds and in write-ahead-log replay situations, and patches over 75 other reported bugs. PostgreSQL [Is PostgreSQL Good Enough?](http://renesd.blogspot.com/2017/02/is-postgresql-good-enough.html?utm_source=postgresweekly&utm_medium=email)Can Postgres be ‘good enough’ for all sorts of different use cases? Time series, object stores, pubsub, realtime, and more are covered here. Rene Dudfield [Postgres Worst Practices (A Slidedeck)](http://www.slideshare.net/PostgreSQL-Consulting/postgresql-worst-practices-version-fosdem-pgday-2017-by-ilya-kosmodemiansky?utm_source=postgresweekly&utm_medium=email)Each slide here describes a _“really bad way people can screw up their PostgreSQL database”_. Ilya Kosmodemiansky [24/7 PostgreSQL support with guaranteed response & resolution times](https://2ndquadrant.com/en/support/support-postgresql/)When it's critical, you can count on us! A Platinum service plan with 2ndQuadrant is all the insurance you need for when things don't go according to plan. Giving you a quick database recovery, with as little downtime as possible. 2ndQuadrant PostgreSQL Services#sponsored[![\](https://copm.s3.amazonaws.com/ac47a1ff.jpg)](https://2ndquadrant.com/en/support/support-postgresql/) [Registration Open for pgDay Asia 2017](https://www.postgresql.org/about/news/1735/?utm_source=postgresweekly&utm_medium=email)A Postgres event in Singapore next month. postgresql.​org#news [Corruption in CREATE INDEX CONCURRENTLY](https://blog.2ndquadrant.com/index-corruption-in-create-index-concurrently/?utm_source=postgresweekly&utm_medium=email)A bug was discovered which can cause index corruption when an index is built via CREATE INDEX CONCURRENTLY (CIC). This explains why. Pavan Deolasee [RethinkDB Versus PostgreSQL: My Personal Experience](http://blog.sagemath.com/2017/02/09/rethinkdb-vs-postgres.html?utm_source=postgresweekly&utm_medium=email)A personal comparison only: _“It’s what I would tell you if we were talking by the water cooler.”_ William Stein [Filling Missing Data & Plugging Gaps by Generating a Continuous Series](http://www.silota.com/docs/recipes/sql-generate-series-filling-gaps.html?utm_source=postgresweekly&utm_medium=email) Silota [PostgreSQL Text Search in Django](http://www.mattlayman.com/2017/postgres-search-django.html?utm_source=postgresweekly&utm_medium=email)Some of the advantages and disadvantages of PostgreSQL full-text search in Django. Matt Layman [Tour de (PostgreSQL) Data Types [PDF\]](https://andreas.scherbaum.la/writings/Tour_de_Data_Types_-_FOSDEM_2017.pdf?utm_source=postgresweekly&utm_medium=email)A handy set of slides covering Postgres’ main data types. Andreas Scherbaum [PostgreSQL At 10TB and Beyond](https://www.youtube.com/watch?v=8mKpfutwD0U&utm_source=postgresweekly&utm_medium=email)Chris Travers discusses what happens when managing over 10 terabytes of data in PostgreSQL. Does it scale and what kinds of problems need to be resolved? Chris Travers#video [Get Instant REST APIs for Postgres](https://www.dreamfactory.com/signup?utm_campaign=signup-07-15-17&utm_content=postgresweekly&utm_medium=external-cooper&utm_source=email&utm_term=postgresql)DreamFactory turns your Postgres database into a comprehensive REST API. Free and open source, [try it now](https://www.dreamfactory.com/signup?utm_campaign=signup-07-15-17&utm_content=postgresweekly&utm_medium=external-cooper&utm_source=email&utm_term=postgresql)! DreamFactory#sponsored    

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