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

Postgres Weekly 147   . 

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

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

[pg_pathman: A Partitioning Tool for Postgres](https://github.com/postgrespro/pg_pathman?utm_source=postgresweekly&utm_medium=email)This module provides an optimized partitioning mechanism and functions to manage partitions. Postgres Professional#code [Postgres Pivot Tables](https://www.garysieling.com/blog/creating-a-pivot-table-in-postgres?utm_source=postgresweekly&utm_medium=email)'Pivoting' in data is a common activity, especially if you’ve ever analyzed data in Excel. It’s also possible to do in Postgres, as demonstrated here. Gary Sieling [An Iterative Approach to Writing SQL](http://bitfission.com/blog/2016/03/iterative-sql.html?utm_source=postgresweekly&utm_medium=email)SQL isn’t always the prettiest language to work with but if you use the right tools, such as Postgres’ CTEs, it can be made easier and you can gradually build up to something clean but powerful. **Disclaimer: Page autoplays MIDI music and is very 1996.** Will Leinweber [Scan and aggregate a 81 GB table in 5 seconds!](http://vitessedata.com/vitesse-db)Vitesse DB Enterprise Edition is PostgreSQL enhanced with builtin multi-threading, LLVM JIT and compressed column store. Check out the TPC-H 100 numbers, and discover why PostgreSQL is ready for reporting and data warehouse. CK Tan#sponsored[![\](https://copm.s3.amazonaws.com/2a22e4af.png)](http://vitessedata.com/vitesse-db) [SQL Performance of JOIN and WHERE EXISTS](http://danmartensen.svbtle.com/sql-performance-of-join-and-where-exists?utm_source=postgresweekly&utm_medium=email)A comparison of the performance and execution paths of inner joins and ‘where exists’ in PostgreSQL 9.5. Dan Martensen [Speeding up Postgres Restores](https://medium.com/@adammckerlie/speeding-up-postgres-restores-de575149d17a?utm_source=postgresweekly&utm_medium=email#.55p72yhf7)In many scenarios you’ll want to pull production data to staging, but the time that takes can be time you’re not testing... This post digs into some ways you can speed up getting a copy of production data elsewhere. Adam McKerlie [Using Regular Expressions in Postgres](http://blog.lerner.co.il/regexps-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Sometimes your database contains things that don’t parse easily with LIKE %, hence you might use a regex. Luckily, Postgres can play really well with regular expressions as seen here. Reuven Lerner [Barman 1.6.0 Released: A Backup and Recovery Manager](http://www.postgresql.org/about/news/1650/?utm_source=postgresweekly&utm_medium=email) postgresql.​org [PostgreSQL Developers, Consultants & Support DBAs at 2ndQuadrant](http://2ndquadrant.com/en/about/careers/)We're in demand ....and that means you could be too!. Due to our continued growth we're looking for people with relevant PostgreSQL skills and experience. [Check out our vacancies.](http://2ndquadrant.com/en/about/careers/) 2ndQuadrant#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/147) [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