#​460 — June 22, 2022

Web Version

Postgres Weekly

Citus 11 for Postgres Goes Fully Open Source — Citus, a Postgres extension for horizontal scaling, was first open sourced six years ago but with the common business model of offering an extended ‘enterprise’ version for money. No longer. Now there’s only one Citus version and it’s all open source, so features like tenant isolation, non-blocking shard rebalancing, and others are now open to all. This is a huge release and well explained in this post.

Marco Slot (Citus Data)

Postgres 14.4 Released — Last week we warned an imminent Postgres 14 update was coming to resolve a nasty bug around silent corruption of indexes when using CREATE INDEX CONCURRENTLY or REINDEX CONCURRENTLY and now it’s here. You can use pg_amcheck to see if you were affected. Non Postgres 14 users remain unaffected.

PostgreSQL Global Development Group

Timestamps & Timezones: What You Need to Know & What You Don’t — Some PostgreSQL programmers are daunted by the date and time data types, and by the effect of the session’s timezone setting on operations. YugabyteDB’s YSQL can result in the same experience. Read about a careful and exhaustive study recently conducted on this topic.

YugabyteDB sponsor


How to Find and Stop Running Queries on Postgres — Postgres is seizing up under the pressure of some troublesome queries or resource constraints and you need to take control fast.. how can you stop those queries without bringing the whole deck of cards down? This post goes into more detail than you’d expect on poking about and taking charge of Postgres’s backend processes.

Adam Johnson

How TimescaleDB 2.7 Makes its Data Aggregation Better and Faster — The folks at Timescale are certainly putting in the work to make it a compelling option for time-series workloads. This post digs deep into some benchmarks showing off just how much faster the new 2.7 release is versus 2.6 with some queries up to 44,000x faster (while typically requiring 60% less storage).

Ryan Booz (Timescale)

Achieving High Uptime with Flexible Server PostgreSQL HA — The “HA” isn’t laughter but High Availability and Azure has introduced a couple of new HA capabilities to its slightly wordy Database for PostgreSQL Flexible Server service.

Sridhar Ranganathan (Microsoft)

🔧 Code and Tools:

The Dalibo Postgres Execution Plan Visualizer — Give this the output from EXPLAIN ANALYZE and get a better view at what Postgres plans to do with your query. Along similar lines to the better known explain.depesz.com but presents the results in a rather different way, so it’s worth trying both. This has been around a while but has seen some recent updates.


Quickly Identify and Address Postgres Queries with Datadog Database Monitoring

Datadog Database Monitoring sponsor

pg_squeeze: An Extension to Fix Table Bloat — While it’s not a replacement for vacuuming, it boasts being a handy extension to go a step further and gain even more space improvements on a table.


pgCluu: Postgres Performance Monitoring and Auditing Tool — A two part tool that collects statistics from a running Postgres cluster and then presents performance information for you to inspect. GitHub repo.

Gilles Darold

Cloudflare Workers Postgres Client — Considered ‘experimental’ for now.


sqlx 0.6 – Async, pure Rust SQL toolkit.
pg-boss 7.4 – Queueing jobs in Node.js using Postgres.
mikro-orm 5.2.1 – TypeScript ORM for Node.js based on Data Mapper.
ruby-pg 1.4 – Postgres client library for Ruby.