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

Postgres Weekly 148   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 148 — March 16, 2016     

[A Quick Look At Postgres' Source Code](http://www.zerobugsandprogramfaster.net/essays/3.html?utm_source=postgresweekly&utm_medium=email)We feature a lot of articles about using Postgres, sometimes some about the community, but rarely a look at the code underneath that powers the database we love. Here’s a great inspection of some of the Postgres core code. Kate Thompson [Hash Indexes on Postgres](http://blog.andrebarbosa.co/hash-indexes-on-postgres/?utm_source=postgresweekly&utm_medium=email)Postgres supports a number of index types, though hash indexes come with a big warning on the box. So why do they even exist? They can yield some extra performance in certain cases as demonstrated here, but use them in production at your own risk. André Barbosa [JSON Field Constraints](http://blog.hagander.net/json-field-constraints-228/?utm_source=postgresweekly&utm_medium=email)A common argument against NoSQL is a lack of enforced conditions around your data. However, with Postgres you can use constraints on your JSON data and enforce good practices. Magnus Hagander [Bruce Momjian Training: Comprehensive PostgreSQL Administration](http://www.enterprisedb.com/store/products/dba-training/01t38000003Lc98AAC?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016AprBruceMclass)Accelerate your learning with training taught by Postgres Community Leader Bruce Momjian. Designed for database professionals responsible for administration and maintenance of PostgreSQL. Increase proficiency and learn best practices. Space is limited – sign up today. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/b426631e.png)](http://www.enterprisedb.com/store/products/dba-training/01t38000003Lc98AAC?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016AprBruceMclass) [No More Full-Table Vacuums](http://rhaas.blogspot.com/2016/03/no-more-full-table-vacuums.html?utm_source=postgresweekly&utm_medium=email)Spawned in part by an email response on the pgsql-hackers list that read “Yeha!”… this followup patch greatly reduces certain cases where full table vacuums are needed. The short of this means the impact of vacuum wraparound is greatly reduced. Robert Haas [How Does Pg_pathman Handle Filter Conditions?](http://akorotkov.github.io/blog/2016/03/14/pg_pathman-condition-processing/?utm_source=postgresweekly&utm_medium=email)pg_pathman is an extension that accelerates query planning over partitioned tables, but how does it work with filters? Alexander Korotkov [Designing a RESTful API with Node and Postgres](http://mherman.org/blog/2016/03/13/designing-a-restful-api-with-node-and-postgres/?utm_source=postgresweekly&utm_medium=email) Michael Herman#tutorial [PipelineDB 0.9 Released with Postgres 9.5 Compatibility](https://www.pipelinedb.com/blog/pipelinedb-0-9-continuous-transforms-streaming-topologies-and-postgresql-9-5-compatibility?utm_source=postgresweekly&utm_medium=email)Pipeline is an open-source relational database that runs SQL queries continuously on streams. PipelineDB#tools [PostgreSQL and Rails, Sitting in A Tree](https://evilmartians.com/chronicles/postgresql-and-rails-sitting-in-a-tree?utm_source=postgresweekly&utm_medium=email)A look at working with large hierarchical structures in Rails with Postgres. Viktor Sokolov#tutorial [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?utm_source=postgresweekly&utm_medium=email)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&utm_source=postgresweekly&utm_medium=email)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/148) [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