Issue 293 - Postgres 11 makes Postgres the leader in window functions again (11)

Postgres 11 Reestablishes Window Functions Leadership — PostgreSQL 11 once again offers the best OVER clause support among its competitors, plus a comparison of Postgres 11’s procedures feature versus other systems like MariaDB and SQL Server.

Postgres 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 Released — Another barrage of releases which usually means a lot of widely applicable bugfixes are in place.. that’s true here too, but the main improvement is in Postgres’s usage of fsync() which was, as we reported last week, somewhat incorrect till now.

Metrics to Monitor in Your PostgreSQL Database — There are several key metrics you’ll want to keep track of when it comes to database performance, and they’re not all database-specific.

DigitalOcean Introduces a Managed Postgres Service — DigitalOcean joins other providers like AWS, Google, MS Azure, and Heroku in offering managed Postgres instances. These look particularly great if you want something on a tight budget. Here’s a list of the installed extensions (which includes TimescaleDB, intriguingly).

How Much maintenance_work_mem Do You Need? — work_mem is a key configuration setting for your database, but it can be confusing to understand how much you need. Robert Hass, Postgres committer, highlights the problem and attempts to explain why things are as they are.

Geo-Redundancy of Postgres Backups with Barman — Barman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a Postgres database.

Master-Replica & Master-Master PostgreSQL Architectures — Learn about the different ways to achieve high-availability for your PostgreSQL environment.

Looking at MySQL 8 with Postgres Goggles On — If you’re a heavy Postgres user, you might not have taken a look at MySQL for many years. But if you’re curious what MySQL is like now, Kaarel has done the looking for you and even finds some features he’d welcome in Postgres.

What is Citus? Scale-Out Clustering and Sharding for Postgres — Microsoft acquired Citus Data a few weeks ago, but what does their technology even do? This is a good high level explanation.