Postgres Weekly Issue 450: April 13, 2022

#450 — April 13, 2022

Multiranges in Postgres 14 — Ranges are usually quite simple: all integers between 5 and 12 – things like that. But multiranges, as supported in Postgres 14, take things to a further level by being able to represent multiple ranges in a composite way. Hans-Jürgen gives us some examples here.

Hans-Jürgen Schönig

PostGIS for Newbies — The PostGIS extension turns Postgres into a geospatial/geographical powerhouse with support for global geometry, ways to measure physical distance, mapping, and more.

Elizabeth Christensen

Effortless Multi-Cloud DBaaS Built for Developers — YugabyteDB is available as a multi-cloud database-as-a-service created for developers. Create and connect to a scalable, resilient, Postgres-compatible database on AWS or GCP in minutes. No software to install, configure, or manage. Sign up for free.

Yugabyte sponsor

▶ 20 Talks from Citus Con 2022 — Citus Con is a new, virtual event being put on by Microsoft this week, and most of the talks are already available to watch on-demand on YouTube. Some highlights:

Fix your Strings in Postgres by Francesco Tisiot.
Why Postgres is Better Than MySQL for Automated Knob Tuning by Dana Van Aken, co-founder of OtterTune, a database tuning startup.
What I Learned Interviewing the Postgres Community by Andreas Scherbaum, known for his Postgres Person of the Week interviews.
Data modeling for those who want to save time and money by Danielle Monteiro.

Microsoft

In brief:

The PostgreSQL Community Association of Canada has posted an update on a trademark action it has been involved in with Spain's Fundación PostgreSQL.
📅 PGConf NYC 2022 is taking place this September in New York City, and if you want to speak, the call for papers is open until the end of May.

Amazon Aurora PostgreSQL Blue/Green Deployment using Fast Database Cloning — A blue/green deployment is when you create two separate but identical environments to reduce risk and make rollback easier when upgrading the version of an underlying app. Aurora’s fast database cloning makes this a rapid process on AWS RDS.

Muddarajaiah, Sarin, et al. (AWS)

PostgreSQL's Official 'Related Projects' — Postgres isn’t just a database, it’s an entire ecosystem. And while huge lists like Awesome Postgres help paint the big picture, there are a lot of projects more closely related to the Postgres project, such as those running the postgresql.org site, the mailing lists, build farm, event management, and more.

PostgreSQL Global Development Group

▶ Scaling Postgres with Google Cloud and HAProxy — HAProxy is a powerful TCP proxy and load balancer and if you want a lot of control over the load balancing aspect of running a Postgres cluster, it could be a way to go.

High Performance Programming Channel

CockroachDB Provides PostgreSQL Simplicity at Scale. Learn How

Cockroach Labs sponsor

How Postgres Audit Tables Saved Us From Taking Down Production
Matt Dupree

Why Isn’t Postgres Using My Index?
Michael Christofides

🔧 Code and Tools:

pgBadger 11.8: A Postgres Log Analysis Tool — A performance-focused log analyzer that produces detailed usage reports. Here’s some example output.

Gilles Darold

SQLFluff: A SQL Linter 'for Humans' — Built in Python, a SQL linter that covers a variety of dialects (including Postgres, of course).

Alan Cruickshank

pgcopydb: Copy a Postgres Database to a Target Postgres Server — Automates running pg_dump | pg_restore between two running Postgres servers.

Dimitri Fontaine