Hubert (depesz) Lubaczewski

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.

performance monitoring memory management postgresql

0 0

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.

postgresql Database Constraints Schema Migration

0 0

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.

postgresql Password Hashing Pgcrypto

0 0

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.

sql postgresql Database Backup

0 0

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.

json functions database

0 0

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.

postgresql Database Performance Gin Indexes

0 0

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.

postgresql performance tuning Query Optimization

0 0

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 sql postgresql

0 0

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.

database postgresql Logging

0 0

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.

performance monitoring database postgresql

0 0

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

0 0

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.

postgresql Database Development SQL Syntax

0 0

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.

postgresql performance tuning Database Configuration

0 0