---
title: "#219: PgHero 2.0 - A Performance Dashboard for Postgres "
publication: "Postgres Weekly"
issue: 219
published_at: "2017-08-09"
canonical_url: "https://postgresweekly.com/issues/219"
---

Postgres Weekly 219   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 219 — August 9, 2017     

[PgHero 2.0: A Performance Dashboard for Postgres](https://medium.com/@ankane/pghero-2-0-has-arrived-266c3874d012?utm_source=postgresweekly&utm_medium=email)Available as a Rails engine, Linux package, and Docker image, PgHero provides an overview of health checks, suggested indexes, and more. Andrew Kane [4 Methods for Joining Data From Multiple Postgres Databases](http://www.cybertec.at/joining-data-from-multiple-postgres-databases/?utm_source=postgresweekly&utm_medium=email)Sometimes you need to join or search data from multiple independent databases to present it as one logical entity. Kaarel Moppel [Heroku Postgres Updates: Configuration, Credentials, and CI](https://blog.heroku.com/postgres-configuration-credentials-ci?utm_source=postgresweekly&utm_medium=email)Postgres is a core part of the Heroku hosting experience and they’re now making it more flexible with custom settings available to production users. Heroku#news [Find the perfect match for your PostgreSQL database](https://selectstar.io/database/postgresql/)Pair PostgreSQL’s open-source roots with SelectStar’s comprehensive monitoring for the ideal environment. SelectStar#sponsored[![\](https://copm.s3.amazonaws.com/3875c5cf.png)](https://selectstar.io/database/postgresql/) [Smooth Operator Having Fun with CREATE OPERATOR](https://blog.2ndquadrant.com/pg-phriday-smooth-operator/?utm_source=postgresweekly&utm_medium=email)Postgres has a lot of powerful operators, but when there’s not a built-in, did you know you can easily create your own? 2ndQuadrant [Principles of Sharding for Relational Databases](https://www.citusdata.com/blog/2017/08/09/principles-of-sharding-for-relational-databases/?utm_source=postgresweekly&utm_medium=email)Opinions on sharding range from "it saved us" to "it was the worst mistake we made". This post looks at the key factors that play into sharding and whether it’s right for you. OZGUN ERDOGAN [E-Maj 2.1.0: Write-Log and Table Update Rollback Extension](https://www.postgresql.org/about/news/1769/?utm_source=postgresweekly&utm_medium=email)An extension which enables fine-grained write logging and ‘time travel’ on subsets of a database. [Docs here.](http://emaj.readthedocs.io/en/latest/) Philippe Beaudoin#news [PostgresOpen Silicon Valley Conference Schedule](https://postgresql.us/events/schedule/pgopen2017/?utm_source=postgresweekly&utm_medium=email)Postgres Open Silicon Valley is a month away and the full schedule is live. US PostgreSQL Association#news [PostGIS 2.4.0 Alpha Released](http://postgis.net/2017/08/05/postgis-2.4.0alpha/?utm_source=postgresweekly&utm_medium=email)The first version of PostGIS (the spatial/geographic extension) to support PostgreSQL 10. Regina Obe#news [A Simple Intro to Logical Replication in Postgres 10](https://medium.com/@tk512/postgresql-logical-replication-86df5b51cc5a?utm_source=postgresweekly&utm_medium=email) Torbjørn Kristoffersen [How to Rotate PgBouncer Logs on Linux and Windows](https://community.postgresrocks.net/t5/Postgres-Gems/How-do-I-rotate-PgBouncer-logs-in-Linux-Windows/ba-p/413?utm_source=postgresweekly&utm_medium=email)[PgBouncer](https://pgbouncer.github.io/) is a lightweight connection pooler. Postgres Rocks [Linux cloud hosting starting at 1GB of RAM for $5/mo](http://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-sponsored)Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account. Linode#sponsored [Postage: A Postgres Administration Tool](https://www.workflowproducts.com/postage.html?utm_source=postgresweekly&utm_medium=email)An alternative to PGAdmin and psql. Workflow Products#tools [gocmdpev: A Go-Based Postgres Query Visualizer](https://github.com/simon-engledew/gocmdpev?utm_source=postgresweekly&utm_medium=email)Heavily inspired by [pev](https://github.com/AlexTatiyants/pev). Simon Engledew#code    

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