#219: PgHero 2.0 - A Performance Dashboard for Postgres

.

Read this on the Web

Postgres Weekly Issue 219 — August 9, 2017

PgHero 2.0: A Performance Dashboard for Postgres 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 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 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 Pair PostgreSQL’s open-source roots with SelectStar’s comprehensive monitoring for the ideal environment. SelectStar    #sponsored  Smooth Operator Having Fun with CREATE OPERATOR 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 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 An extension which enables fine-grained write logging and ‘time travel’ on subsets of a database. Docs here. Philippe Beaudoin   #news  PostgresOpen Silicon Valley Conference Schedule Postgres Open Silicon Valley is a month away and the full schedule is live. US PostgreSQL Association   #news  PostGIS 2.4.0 Alpha Released 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 Torbjørn Kristoffersen How to Rotate PgBouncer Logs on Linux and Windows PgBouncer is a lightweight connection pooler. Postgres Rocks Linux cloud hosting starting at 1GB of RAM for $5/mo 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 An alternative to PGAdmin and psql. Workflow Products   #tools  gocmdpev: A Go-Based Postgres Query Visualizer Heavily inspired by pev. Simon Engledew   #code  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK