Microsoft Acquires Citus Data, the Postgres Horizontal Scaling Company — Citus has become well known for its eponymous Postgres extension that makes Postgres more easily horizontally scalable. This acquisition is an interesting demonstration of both Microsoft’s commitment to supporting its open source database users on Azure and to Postgres generally.

Microsoft

Lessons Learned Scaling Postgres to 1.2 Billion Records per Month — The experiences of engineers building a cinema tracking service covering 3200 cinemas and 47,000 showtimes a day. They cover how they reviewed providers, experiences with materialized views, and using the database as a job queue.

Gajus Kuizinas

Diagnose & Resolve Performance Across Your PostgreSQL Environment — Manage the health of your infrastructure. Intuitive web-based dashboards alert you to issues that might affect performance or availability, and a clear enterprise-wide view helps you optimize your entire PostgreSQL environment. Download your free trial.

Quest Software sponsor

A Look at Six Top GUI Tools for Postgres — Using a GUI is rarely a must, but GUI-based tools can be useful in some cases. Here’s a brief review of five options including pgAdmin, Navicat and ClusterControl.

Sebastian Insausti (Severalnines)

Terrific Throughput Tracking for Postgres — Did you know it’s possible to use some of Postgres’s built-in information functions to monitor the throughput of your instance?

Shaun Thomas (2ndQuadrant)

Amazon RDS for PostgreSQL Now Supports T3 Instance Types — One for the AWS users. T3 instances are the newer form of ‘burstable’ instances and particularly suited for intermittent usage.

Amazon Web Services, Inc.

A Major Feature Update for the pgwatch2 Postgres Monitoring Tool — pgwatch2 is a popular self-contained Postgres metrics monitoring and dashboard system.

Kaarel Moppel

eBook: Best Practices for Optimizing Postgres Query Performance — Learn how to get a 3x performance improvement on your Postgres database and 500x reduced data loaded from disk in this free pganalyze eBook.

pganalyze sponsor

A Flowchart of Postgres's Backend — A diagram of how Postgres works behind the scenes. You can click on each item to get more information.

PostgreSQL Global Development Group

Scheduling Backups En Masse with the Postgres Operator — A solid disaster recovery plan for Postgres clusters combined with pgBackRest and the Crunchy PostgreSQL Operator will help you manage your backups across thousands of instances with only a few commands.

Jonathan S. Katz

DB Doc 6.0 Released: A Postgres Schema Documentation Tool — A commercial tool (with trial). Now supports Postgres 11.

Yohz Software