A command line interface to look at lots of different Postgres stats and information live has taken some key steps forward. Github repo.

psql 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.

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.

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.

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.

Fancy a step back in time? The preliminary design of PostgreSQL (when it was called POSTGRES) is outlined in this 1995 paper.

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.

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.

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.