select * from depesz;

Who logged to system from multiple countries in 2 hours?

Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN

pg_dump speed across versions

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

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

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

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.

Waiting for PostgreSQL 18 – Enable BUFFERS with EXPLAIN ANALYZE by default

Waiting for PostgreSQL 18 – Support LIKE with nondeterministic collations

Waiting for PostgreSQL 18 – psql: Add more information about service name

Waiting for PostgreSQL 18 – Add UUID version 7 generation function.

How to ALTER tables without breaking application?

SQL best practices – don’t compare count(*) with 0

How can I send mail or HTTP request from database?

Changes on pgdoc.link

Grouping data into array of sums – fun with custom aggregates

System views added to pgdoc.link

Waiting for PostgreSQL 18 – Add SQL function array_reverse()

New way to search PostgreSQL documentation

Case study: optimization of weirdly picked bad plan

SQL/JSON is here! (kinda “Waiting for Pg 17”)