Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 180 — October 26, 2016
pgCenter 0.3.0: A 'top'-Like PostgreSQL Statistics Viewer
A command line interface to look at lots of different Postgres stats and information live has taken some key steps forward. Github repo.
Alexey Lesovsky   #news 
Production psql Prompts
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.
Scott Mead
Date Functions (and 7 Ways to Use Them in Business Analysis)
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
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 
PGConf US 2017 - Call for Presentations
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]
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
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
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
Chris Aumann   #tools 
Job Offers Without the Hassle - Try Hired
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.