---
title: "This Week's PostgreSQL News (#86)"
publication: "Postgres Weekly"
issue: 86
published_at: "2014-12-18"
canonical_url: "https://postgresweekly.com/issues/86"
---

Postgres Weekly Issue 86 - December 18, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/86)**Postgres Weekly****Issue 86**
December 18, 2014Due to the Christmas break, we'll be back on January 8th. Happy Holidays![PostgreSQL 9.4 Released: Increases Flexibility, Scalability and Performance](http://www.postgresql.org/about/news/1557/?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 is finally here including improved scalability with logical decoding performance gains with updates to GIN indexes and more, and of course the very much awaited JSONB datatype for even more flexibility in your datatypes. Give it a try today._postgresql.org_[Substitute PostgreSQL for Your NoSQL Needs](http://news.dice.com/2014/11/24/substitute-postgresql-nosql-needs/?utm_source=postgresweekly&utm_medium=email)SQL, NoSQL, KnowSQL are heavily overloaded terms. Postgres has long taken a liberal approach to datatypes and schema-less datatypes play very well in its world. Here’s a broader article that hints at much of this if you need a case vs. relational/NoSQL because with Postgres you really can have your cake and eat it too._Dice_[Adventures in Searching with Postgres: Part 2](http://blog.carbonfive.com/2014/12/12/adventures-in-searching-with-postgres-part-2/?utm_source=postgresweekly&utm_medium=email)Searching is a common theme lately, specifically text search in Postgres. While not always the most user-friendly feature, it’s undoubtedly powerful and in this article we dive deeper into some of the semantics of text search and how to take advantage of the features._Matt Wean_[Japan PostgreSQL Conference 2014](http://blog.2ndquadrant.com/japan-postgresql-conference-2014/?utm_source=postgresweekly&utm_medium=email)The number of Postgres conferences seems to just continue growing. Here’s a nice write-up of Japan’s latest Postgres conference and some of the themes that emerged from it.[SQLnoSQL: pg_shard and JSONB, part 1](http://www.databasesoup.com/2014/12/sqlnosql-pgshard-and-jsonb-part-1.html?utm_source=postgresweekly&utm_medium=email)We now have a working example and demo of using the pg_shard extension alongside the JSONB format, giving us all the perks of Postgres, solid sharding, and the flexibility of a schema-less datastore all in one._Josh Berkus_[Job: Help Chain.com Index the Block Chain](https://jobs.lever.co/chain/1b197453-0bf4-442c-be3f-d3cede60c5d4?utm_source=postgresweekly&utm_medium=email)Chain.com is the API for block chain developers. We have an experienced engineering team who is dedicated to building the world’s best Bitcoin platform. We are looking for a PostgreSQL expert to join the Data Engineering team._Chain.comJob_[This Week's Issue of Database Weekly](http://dbweekly.com/issues/43?euid=*|UNIQID|*?utm_source=postgresweekly&utm_medium=email)DB Weekly covers general database trends, graph databases, NoSQL, tools, and more. [Issue 43](http://dbweekly.com/issues/43?euid=*|UNIQID|*) looks at how to choose a database, creating test databases full of fake data, an OS X database management tool, and more._Cooper Press_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)