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

Postgres Weekly 180   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 180 — October 26, 2016     

[pgCenter 0.3.0: A 'top'-Like PostgreSQL Statistics Viewer](http://blog.postgresql-consulting.com/2016/10/030-is-out.html?utm_source=postgresweekly&utm_medium=email)A command line interface to look at lots of different Postgres stats and information live has taken some key steps forward. [Github repo](https://github.com/lesovsky/pgcenter). Alexey Lesovsky#news [Production psql Prompts](http://www.openscg.com/2016/10/production-psql-prompts/?utm_source=postgresweekly&utm_medium=email)[psql](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/) is a great Postgres client. If you use it a lot, consider customizing it to highlight the environment you’re working with as demonstrated here. Scott Mead [Date Functions (and 7 Ways to Use Them in Business Analysis)](https://blog.modeanalytics.com/postgres-sql-date-functions/?utm_source=postgresweekly&utm_medium=email)PostgreSQL date functions (like DATE_TRUNC, EXTRACT, and AGE) make wrangling timestamps easier. Here are seven examples of applying these date functions to business scenarios. Joel Carron [PostgreSQL Database Hosting – Unlimited Deployments FREE for 30 Days](https://compose.com/postgresql/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres)Cloud-hosted, reliable multi-node cluster. Automatic failover and managed disaster recovery. Real-time monitoring dashboard and automated alerts. Hosted on AWS, SoftLayer or Google Cloud Platform. Deploy your DB in minutes. Compose#sponsored[![\](https://copm.s3.amazonaws.com/f9c59f11.png)](https://compose.com/postgresql/?utm_source=cooper&utm_medium=newsletter&utm_content=postgres) [PGConf US 2017 - Call for Presentations](http://www.pgconf.us/2017/submit/?utm_source=postgresweekly&utm_medium=email)The 2017 PGConf US will be held in Jersey City, New York in March next year. Call for presentations are now open until November 15th. PGConf US#news [The Design of Postgres [PDF\]](http://db.cs.berkeley.edu/papers/ERL-M85-95.pdf?utm_source=postgresweekly&utm_medium=email)Fancy a step back in time? The preliminary design of PostgreSQL (when it was called POSTGRES) is outlined in this 1995 paper. Michael Stonebraker and Lawrence A.​ Rowe [Quick Stats with pgBadger](http://www.openscg.com/2016/10/quick-stats-with-pgbadger/?utm_source=postgresweekly&utm_medium=email)There’s a number of options to get stats and insights into Postgres, from internal values like `pg_stat_statements` to logging things to external systems. This guide will get you set up with one of the more popular tools: pg_badger. Scott Mead [Waiting for PostgreSQL 10: Push Down Aggregates to Remote Servers](https://www.depesz.com/2016/10/25/waiting-for-postgresql-10-postgres_fdw-push-down-aggregates-to-remote-servers/?utm_source=postgresweekly&utm_medium=email)Postgres 9.6 has been here for a few weeks, so we can begin to look ahead to the next release, 10. Coming in Postgres 10: the Postgres FDW gets a big improvement: aggregate pushdown. Hubert depesz Lubaczewski [pg-cert-check: A Tool to Monitor Postgres Database SSL Certificates](https://chr4.org/blog/2016/10/24/pg-cert-check-a-tool-to-monitor-postgresql-database-ssl-certificates/?utm_source=postgresweekly&utm_medium=email) Chris Aumann#tools [Job Offers Without the Hassle - Try Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Sick of pushy recruiters, and dead end interviews? Try Hired to hear from over 4,000 innovative companies looking for their next great team member. Hired#sponsored    

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