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

Postgres Weekly 144   . 

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

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

[PGConf US 2016 Schedule Posted; Registration Open](http://www.postgresql.org/about/news/1646/?utm_source=postgresweekly&utm_medium=email)PGConf US 2016 is taking place in New York City from April 18th to April 20th at the New York Marriott Brooklyn Bridge. A ‘20th birthday party’ for Postgres will be taking place on the 19th and is open to the general public. Postgresql.​org#news [Hunting Down Phantom Write Spikes in RDS Postgres](http://blog.pixlee.com/hunting-down-phantom-write-spikes-in-rds-postgres?utm_source=postgresweekly&utm_medium=email)A team was noticing every 6-12 hours, their RDS write throughput would spike significantly. This is a look at how they dug into it and resolved the issue. Jeff Chen#tutorial [Custom Aggregates in PostgreSQL](https://hashrocket.com/blog/posts/custom-aggregates-in-postgresql?utm_source=postgresweekly&utm_medium=email)Finding the greatest running total across data is a great exercise with which to explore some of the lesser known features of PostgreSQL such as window functions, custom aggregates, and even implementing functions in C. Jack Christensen#tutorial [Webinar: Making the Most of Your Postgres Rollout](http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/making-most-your-postgres-rollout?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016WebinarGetStart)Looking for guidance to ensure a successful Postgres rollout? Join EDB for an informative webinar where we will share best practices and lessons learned from more than a decade of helping enterprises get started with new Postgres implementations on Wednesday, February 24 at 1pm EST. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/e38dfaad.png)](http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/making-most-your-postgres-rollout?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016WebinarGetStart) [PostgreSQL 9.5.1 Released](http://www.postgresql.org/docs/9.5/static/release-9-5-1.html?utm_source=postgresweekly&utm_medium=email)A minor bug-fix release. PostgreSQL#news [Creating Partitions Automatically in PostgreSQL](https://medium.com/@StreamBright/creating-partitions-automatically-in-postgresql-7006d68c0fbb?utm_source=postgresweekly&utm_medium=email)Why should you ever split up a table into smaller chunks? Here’s a very quick look at what partitioning involves and how it’s done. StreamBright#tutorial [PostgreSQL [9.5.0\] vs MariaDB [10.1.11\] vs MySQL [5.7.0\]](http://nghenglim.github.io/PostgreSQL-9.5.0-vs-MariaDB-10.1.11-vs-MySQL-5.7.0-year-2016/?time=1&utm_source=postgresweekly&utm_medium=email)As always, take once-off benchmarks with a pinch of salt, but Postgres stands up very well here. Ng Heng Lim#opinion [Persistent PostgreSQL Inside Docker](https://crondev.com/persistent-postgresql-inside-docker/?utm_source=postgresweekly&utm_medium=email) Cron [String Parsing in SQL](https://www.periscopedata.com/blog/string-parsing-in-sql.html?utm_source=postgresweekly&utm_medium=email)A quick look at string searching methods and using regular expressions in SQL Periscope [Little_PGer.py: A Thin Layer Just A Tad Above SQL, to Use with PostgreSQL and Psycopg2](https://github.com/cjauvin/little_pger?utm_source=postgresweekly&utm_medium=email)One for Pythonistas. Christian Jauvin#code [PostgreSQL Platform Engineer at Compose (Remote - US/UK/CAN)](https://compose.io/jobs?utm_source=postgresweekly&utm_medium=email#platform-engineer)Compose is looking to provide the best managed PostgreSQL. If you love PostgreSQL, have experience working with distributed systems, and love solving fun data-related problems, we have the perfect opportunity for you. Compose, an IBM company#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/144) [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