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

Postgres Weekly 134   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 134 — December 2, 2015     

[Announcing PGConf US 2016: Apr 18-20, NYC](http://www.postgresql.org/about/news/1628/?utm_source=postgresweekly&utm_medium=email)The call for presentations for PGConf US 2016 is now open. Submissions will be allowed through January 31st, 2016. postgresql.​org [Node, Postgres, MassiveJS: A Better Database Experience](http://www.craigkerstiens.com/2015/11/30/massive-node-postgres-an-overview-and-intro/?utm_source=postgresweekly&utm_medium=email)Postgres isn’t the default database choice for many Node developers, but perhaps that’s because a good Postgres library hasn’t come along. So if you’re looking for a reason to try Node and Postgres, take a look at MassiveJS. Craig Kerstiens [Scale Out Postgres for Real-Time Big Data Using CitusDB](http://info.citusdata.com/BigDataPW4.html)CitusDB delivers [real-time insights](http://info.citusdata.com/BigDataPW3.html) into your Big Data while reducing the cost and complexity of your database infrastructure and leverages your existing knowledge and applications. Supports structured or unstructured data and [horizontally scales.](http://info.citusdata.com/BigDataPW3.html) Citus Data#sponsored[![\](https://copm.s3.amazonaws.com/8aa06404.png)](http://info.citusdata.com/BigDataPW4.html) [Using Ansible to Set Up PostgreSQL](http://blog.apcelent.com/using-ansible-to-setup-postgresql.html?utm_source=postgresweekly&utm_medium=email)A tutorial walking through the entire process of using the Ansible configuration management and remote task execution system to deploy Postgres to a server. Apcelent Blog [Indexing and Querying Postgres Hstore](http://blog.nordeus.com/dev-ops/indexing-and-querying-postgres-hstore.htm?utm_source=postgresweekly&utm_medium=email)Hstore is an awesome flexible datatype within Postgres–a key/value store directly in a single column. Here’s the rundown of how you can work with it as well as index it for great performance in addition to all that flexibility. Vladimir Mihajlovski [3 Reasons to Use PgBouncer](http://blog.postgresql-consulting.com/2015/06/3-reasons-to-use-pgbouncer.html?utm_source=postgresweekly&utm_medium=email)PgBouncer is probably the best connection pooling tool out there, and if you’re not familiar on why to use a connection pooler and in particular PgBouncer just give this a read. Alexey Lesovsky#opinion [Parallel Sequential Scans in Play](http://amitkapila16.blogspot.com/2015/11/parallel-sequential-scans-in-play.html?utm_source=postgresweekly&utm_medium=email)Parallel scans will be one of the key features landing in Postgres 9.6 - if you’re looking for a good overvie, look no further than here. Amit Kapila [Parallel Sequence Scan and PostGIS](https://gist.github.com/pramsey/84e7a39d83cccae692f8?utm_source=postgresweekly&utm_medium=email)Parallel scans will mean some great performance improvements for Postgres and continue to lay a foundation for scalability, and because of Postgres’ extensible nature it applies not only to stock relational PG but also to features like PostGIS. Paul Ramsey#code [nyc-taxi-data: Import Public NYC Taxi and Uber Trip Data into PostgreSQL](https://github.com/toddwschneider/nyc-taxi-data?utm_source=postgresweekly&utm_medium=email)Import public NYC taxi and Uber trip data into PostgreSQL / PostGIS database, analyze with R or whatever you wish. GitHub#code [Full-Stack Engineer at VTS (New York, NY)](http://grnh.se/rufpy6?utm_source=postgresweekly&utm_medium=email)VTS is creating the next generation of Commercial Real Estate tools for brokers and landlords. We're experiencing record breaking month over month growth and are looking for talented engineers to swim in the deep end with us (RoR/AngularJS/PostgreSQL) vts.​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! Indeed#job    

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