We covered when Mark analyzed a billion rides in Redshift, now here’s the same but using Postgres and cstore, the columnar storage FDW from Citus Data.

Some developers didn’t want to write PL/SQL to make complex triggers and procedures, so they decided to try Lua instead.

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.

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.

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.

A post highlighting some of the numbers and potential performance improvements of parallel aggregation now being in Postgres.

PipelineDB is a database based off of Postgres but that adds continuous, streaming SQL query functionality.

A look at an extension for Postgres that introduces Sphinx’s advanced full-text search features.

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.

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.

jpgAgent is a job scheduler for PostgreSQL written in Java. It aims for low overhead, and to be fully compatible with pgAgent.

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.