#399 — March 31, 2021

Web Version

Postgres Weekly

How The Postgres Optimizer Works and Speeds Up Queries — Last week we saw how to use EXPLAIN to analyze queries and see what the query execution planner’s decisions are, but this post goes into a lot more practical depth on the sort of optimizations that take place behind the scenes.

Hans-Jürgen Schönig

Speeding Up Recovery and VACUUM in Postgres 14 — Postgres 14 isn’t yet with us but numerous developers are hard at work on implementing new features for this, including David Rowley who’s been making big improvements to crash recovery performance. Here he explains how it works.

David Rowley

🌍 CYBERTEC Spatial Services 🌎 Are Your Databases GIS Ready? — Present huge data sets with easy understandable maps and dashboards, and analyse data from a geographic perspective. We can help you with implementing spatial infrastructure, GIS training and database optimization as well as spatial analysis.

CYBERTEC sponsor

Speeding Up SQL Queries by Orders of Magnitude with UNION — SQL’s UNION operation isn’t usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.

Ben Levy and Christian Charukiewicz

When to Use Tablespaces — Tablespaces are essentially locations in the file system where data representing database objects can be stored and they make it possible to define different places to store different databases, indexes, and other objects.

Laurenz Albe

Key Considerations in Moving to Graviton2 (ARM) for Amazon RDS and Amazon Aurora Databases — Having developed its own ARM-based chips that promise more performance at a lower price, AWS is rather keen to get your database workloads shifted over to them – here’s the process they expect users to take.

Reagan Rosario and Tyler Lynch (AWS)

Best-Practices on How to Speed Up Your Postgres Queries. Free eBook — We share our learnings from helping companies like Atlassian, CounterPath, and others speed up their queries.

pganalyze sponsor

Exploring PL/Python: Turn Postgres Table Data Into a NumPy Array

Kat Batuigas

A Glance at using Postgres From Raku — Raku is the language originally known as Perl 6.

Luca Ferrari

🔧 Tools and Code

A First Look at pg_repackpg_repack is an extension for removing bloat from tables and indexes but without holding an exclusive lock over them during processing.

Luca Ferrari

pg_timetable 3.7.0: Advanced Job Scheduling for Postgres

CYBERTEC PostgreSQL International GmbH

pgAdmin 5.1: The Popular Postgres Admin Dashboard — You can now zoom in and out more easily within the interface.

pgAdmin Development Team

pg_auto_failover 1.5: Automated Failover and High-Availability Extension — Monitors and manages automated failover for a Postgres cluster.

Citus Data