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

Postgres Weekly 145   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 145 — February 24, 2016     

[Four PostgreSQL Tips](http://jakeyesbeck.com/2016/02/21/four-postgresql-tips/?utm_source=postgresweekly&utm_medium=email)Postgres is packed with so many useful features that it makes it hard to keep up with everything you may find beneficial. Here’s one list of four incredibly useful tips that may come in handy the next time you’re running a query. Jake Yesbeck [Replacing EAV with JSONB in PostgreSQL](http://coussej.github.io/2016/01/14/Replacing-EAV-with-JSONB-in-PostgreSQL/?utm_source=postgresweekly&utm_medium=email)The practical examples of using JSONB are continuing to arrive. This post demonstrates an old and new way of doing an entity-attribute-value data structure directly in Postgres. Jeroen Coussement#code [Scan and aggregate on a 81 GB table in 5 seconds!](http://vitessedata.com/vitesse-db)Vitesse DB Enterprise Edition is PostgreSQL for OLAP/BI enhanced with built-in multi-threading, LLVM JIT and compressed column storage. Check out the TPC-H 100 number. A PostgreSQL solution is at hand for Reports and Data Warehouse. Vitesse Data, Inc.​ #sponsored[![\](https://copm.s3.amazonaws.com/5297c6c4.png)](http://vitessedata.com/vitesse-db) [Sorting Through The Ages [PDF\]](https://wiki.postgresql.org/images/5/59/Sorting_through_the_ages.pdf?utm_source=postgresweekly&utm_medium=email)Often when you execute a query there’s some form of sort that’s executed under the covers. Here’s an amazing slide-based tour of the development of sorting functionality and the impact made over the years. postgresql.​org [Postgres-XL 9.5 R1 Beta1 Announced](http://2ndquadrant.com/en/resources/postgres-xl/?utm_source=postgresweekly&utm_medium=email)Postgres-XL is a massively parallel database built on top of, and very closely compatible with, PostgreSQL 9.5. 2ndQuadrant [Foreign Data Wrappers with PostgreSQL and PHP](http://gonzalo123.com/2016/02/22/foreign-data-wrappers-with-postgresql-and-php/?utm_source=postgresweekly&utm_medium=email)Foreign Data Wrappers and extensions continue to allow Postgres to be more than just a relational database. Here’s a look at one example of how to use a FDW with PHP. Gonzalo Ayuso [Side Effects of Using .first_or_create! at Scale in Rails](http://aserafin.pl/2016/02/19/side-effects-of-using-first-or-create-at-scale/?utm_source=postgresweekly&utm_medium=email)Frameworks can make lives easier and help you avoid the details, but sometimes the out-of-box behavior becomes problematic when you have any sizable amount of data. Here’s an example of that in Rails. Adrian Serafin [Chain works with Visa/Nasdaq to digitize money & you'll never guess which RDBMS we use](https://jobs.lever.co/chain/1a22df50-4600-4ea2-80ce-89853bad056c)Come work with us as we rethink the tech stack for financial services. We need folks who are experts in database systems and are eager to make a big impact. Chain.​com#job [Postgres Skills are in demand](http://www.indeed.com/prime?sid=xp_cooperpress&kw=postgres)Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. [Join today.](http://www.indeed.com/prime?sid=xp_cooperpress=postgres) Indeed.​com#job    

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