Postgresql articles

5/22/2025 • EN

pg_dump speed across versions

Benchmarking pg_dump performance across PostgreSQL versions 10-18, revealing speed changes and regression in recent versions.

benchmark Database Backup performance Pg_dump postgresql

Hubert (depesz) Lubaczewski

5/22/2025 • EN

Debugging memory leaks in Postgres, heaptrack edition

A technical guide on using heaptrack to debug memory leaks in PostgreSQL, with examples of introducing and detecting leaks in C code.

c programming debugging Heaptrack Memory Leaks postgresql

Phil Eaton

5/5/2025 • EN

Waiting for PostgreSQL 18 – Add function to get memory context stats for processes

PostgreSQL 18 adds a function to retrieve detailed memory context statistics from any backend or auxiliary process for debugging memory issues.

Database Debugging memory management performance monitoring postgresql Process Monitoring

Hubert (depesz) Lubaczewski

5/1/2025 • EN

Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID

PostgreSQL 18 introduces NOT VALID for NOT NULL constraints, allowing addition without table scans and validation with reduced locking.

Alter Table Database Constraints Not Null postgresql Schema Migration

Hubert (depesz) Lubaczewski

4/17/2025 • EN

Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.

PostgreSQL 18 adds modern SHA-256 and SHA-512 password hashing algorithms to the pgcrypto extension, enhancing security.

Password Hashing Pgcrypto postgresql Sha 256 Sha 512

Hubert (depesz) Lubaczewski

4/15/2025 • EN

Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore

PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.

Database Backup Pg_dumpall Pg_restore postgresql sql

Hubert (depesz) Lubaczewski

$Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements$

3/13/2025 • EN

Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements

PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.

database functions json Jsonb postgresql

Hubert (depesz) Lubaczewski

3/11/2025 • EN

Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes

PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.

Database Performance Gin Indexes Index Creation Parallel Indexing postgresql

Hubert (depesz) Lubaczewski

$Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.$

2/28/2025 • EN

Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.

PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.

Database Internals Explain performance tuning postgresql Query Optimization

Hubert (depesz) Lubaczewski

2/28/2025 • EN

Waiting for PostgreSQL 18 – Virtual generated columns

Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.

database Generated Columns postgresql Relational Databases sql

Hubert (depesz) Lubaczewski

2/28/2025 • EN

Minimal downtime Postgres major version upgrades with EDB Postgres Distributed

A technical guide demonstrating how to perform a minimal-downtime major version upgrade of a PostgreSQL cluster using EDB Postgres Distributed.

Edb High Availability postgres postgresql upgrade

Phil Eaton

2/19/2025 • EN

Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.

PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.

Autovacuum database Logging postgresql Vacuum

Hubert (depesz) Lubaczewski

2/15/2025 • EN

From web developer to database developer in 10 years

A developer shares their 10-year journey from web development to specializing in database engineering, focusing on Postgres and distributed systems.

c Database Development Logical Replication postgresql rust

Phil Eaton

2/13/2025 • EN

Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.

PostgreSQL 18 adds tracking of cost-based vacuum delay time to progress views, helping monitor performance impact of vacuum operations.

database performance monitoring postgresql System Views Vacuum

Hubert (depesz) Lubaczewski

2/10/2025 • EN

Managed Postgres Instance: Neon

A developer's review of Neon, a serverless managed PostgreSQL service, highlighting its branching feature and comparing it to other cloud providers.

database Managed Services Neon postgresql serverless

Steven Giesel

2/9/2025 • EN

Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().

PostgreSQL 18 adds support for converting Roman numerals to numbers using the to_number() function, filling a long-standing gap.

database postgresql roman numerals SQL Functions To_number

Hubert (depesz) Lubaczewski

1/30/2025 • EN

Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.

PostgreSQL 18 adds OLD/NEW support to RETURNING in DML queries, allowing explicit access to previous and new row values.

Database Development Dml postgresql Returning Clause SQL Syntax

Hubert (depesz) Lubaczewski

1/24/2025 • EN

Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.

PostgreSQL 18 will allow dynamic adjustment of autovacuum_max_workers without a server restart, improving database maintenance flexibility.

Autovacuum Database Administration Database Configuration performance tuning postgresql

Hubert (depesz) Lubaczewski

1/17/2025 • EN

Logical replication in Postgres: Basics

A technical guide to setting up and understanding logical replication between two PostgreSQL databases, including setup steps and limitations.

Database Replication Logical Replication Postgres 17 postgresql

Phil Eaton

1/2/2025 • EN

Adding new entries to a Supabase postgres table via REST API

A tutorial on using Python to insert data into a Supabase PostgreSQL table via its REST API.

Backend postgresql Python rest api Supabase

Saeed Esmaili

Postgresql Articles

pg_dump speed across versions

Debugging memory leaks in Postgres, heaptrack edition

Waiting for PostgreSQL 18 – Add function to get memory context stats for processes

Waiting for PostgreSQL 18 – Allow NOT NULL constraints to be added as NOT VALID

Waiting for PostgreSQL 18 – Add modern SHA-2 based password hashes to pgcrypto.

Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore

Waiting for PostgreSQL 18 – Allow json{b}_strip_nulls to remove null array elements

Waiting for PostgreSQL 18 – Allow parallel CREATE INDEX for GIN indexes

Waiting for PostgreSQL 18 – Allow EXPLAIN to indicate fractional rows.

Waiting for PostgreSQL 18 – Virtual generated columns

Minimal downtime Postgres major version upgrades with EDB Postgres Distributed

Waiting for PostgreSQL 18 – Add delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs.

From web developer to database developer in 10 years

Waiting for PostgreSQL 18 – Add cost-based vacuum delay time to progress views.

Managed Postgres Instance: Neon

Waiting for PostgreSQL 18 – Support RN (roman-numeral format) in to_number().

Waiting for PostgreSQL 18 – Add OLD/NEW support to RETURNING in DML queries.

Waiting for PostgreSQL 18 – Allow changing autovacuum_max_workers without restarting.

Logical replication in Postgres: Basics

Adding new entries to a Supabase postgres table via REST API

Select Language