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

Postgres Weekly 150   . 

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

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

[Analyzing A Billion Taxi Rides in PostgreSQL](http://tech.marksblogg.com/billion-nyc-taxi-rides-postgresql.html?utm_source=postgresweekly&utm_medium=email)We covered when Mark analyzed a billion rides in [Redshift](http://tech.marksblogg.com/billion-nyc-taxi-rides-redshift.html), now here’s the same but using Postgres and [cstore](https://github.com/citusdata/cstore_fdw/), the columnar storage FDW from [Citus Data](http://www.citusdata.com). Mark Litwintschik [Using Lua in PostgreSQL with PLLua](http://www.newfies-dialer.org/using-lua-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Some developers didn’t want to write PL/SQL to make complex triggers and procedures, so they decided to try Lua instead. Areski Belaid#tutorial [Waiting for 9.6 – Support Parallel Aggregation](http://www.depesz.com/2016/03/23/waiting-for-9-6-support-parallel-aggregation/?utm_source=postgresweekly&utm_medium=email)Parallel aggregation may end up being the marquee feature in Postgres 9.6, allowing you to take advantage of multiple worker processes providing more parallelism. Here’s the second look in as many weeks at the feature this time with some early performance numbers. Hubert depesz Lubaczewski [Postgres Vision 2016 Conference: Future of Enterprise Postgres Open Source DM](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016PGVisionPR)Postgres Vision focuses on current and future enterprise usage of Postgres. This event includes insights from technology and business luminaries, use cases, a look at the Postgres ecosystem, and long-range outlooks from analysts. Visit PostgresVision.com. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/19eebb61.png)](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?utm_source=cooperpress&utm_medium=nl&utm_campaign=2016PGVisionPR) [Citus Unforks From PostgreSQL, Goes Open Source](https://www.citusdata.com/blog/17-ozgun-erdogan/403-citus-unforks-postgresql-goes-open-source?utm_source=postgresweekly&utm_medium=email)Citus Data has released Citus 5.0 which comes along with two major announcements. The first is it’s entirely an extension, making it the first distributed database to not fork Postgres but use native extension APIs. The second, it’s now [open source](http://github.com/citusdata/citus). Citus Data#news [Parallel Aggregate: Getting The Most Out of Your CPUs](http://blog.2ndquadrant.com/parallel-aggregate/?utm_source=postgresweekly&utm_medium=email)A post highlighting some of the numbers and potential performance improvements of parallel aggregation now being in Postgres. David Rowley#tutorial [Streaming SQL with PipelineDB [PDF\]](https://wiki.postgresql.org/images/a/ad/South_Bay_PG_Meetup_2016-03-08_PipelineDB.pdf?utm_source=postgresweekly&utm_medium=email)PipelineDB is a database based off of Postgres but that adds continuous, streaming SQL query functionality. Derek Nelson#tools [PostgreSQL and Sphinx Search Seamless Integration](https://anadea.info/blog/postgresql-and-sphinx-search-seamless-integration?utm_source=postgresweekly&utm_medium=email)A look at an extension for Postgres that introduces Sphinx’s advanced full-text search features. Andrey Kutejko#tutorial#tools [Embrace SQL with HugSQL, Clojure and PostgreSQL](https://compose.io/articles/embrace-sql-with-hugsql-clojure-and-postgresql/?utm_source=postgresweekly&utm_medium=email)HugSQL puts SQL front and center of your development instead of obfuscating it with an ORM. Take a look at using it with your Clojure apps. Compose Articles#tutorial [PostgreSQL and Per-Connection Write Consistency Settings](https://compose.io/articles/postgresql-and-per-connection-write-consistency-settings/?utm_source=postgresweekly&utm_medium=email)Postgres has a number of options for ensuring your data is committed. While most run with a sane default, you can also be extra safe ensuring it’s committed to a replica. Here’s a deeper look at the options. Chris Winslett#tutorial [Adding Generic Command Progress Reporting to 9.6?](http://www.depesz.com/2016/03/09/waiting-for-9-6-add-a-generic-command-progress-reporting-facility/?utm_source=postgresweekly&utm_medium=email) Hubert depesz Lubaczewski#news [jpgAgent: A PostgreSQL Job Scheduler, Written in Java](https://github.com/Tostino/jpgAgent?utm_source=postgresweekly&utm_medium=email)jpgAgent is a job scheduler for PostgreSQL written in Java. It aims for low overhead, and to be fully compatible with pgAgent. Adam Brusselback#code [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/150) [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