Hubert (depesz) Lubaczewski is a PostgreSQL expert and developer sharing practical tips on database management, query optimization, and tooling. His blog covers PostgreSQL performance, CSV handling, T-SQL formatting, and real-world database workflows.
44 articles from this blog
Explains new PostgreSQL 19 features for synchronizing sequences via logical replication, including ALL SEQUENCES support and a sync worker.
Analyzes the performance and storage trade-offs of using a dedicated tsvector column versus an expression index for full-text search in PostgreSQL.
PostgreSQL 19 adds a new %S prompt variable to psql to display the current search_path, aiding users who frequently work with multiple schemas.
PostgreSQL 19 adds direct COPY TO support for partitioned tables, improving usability and performance over the previous SELECT workaround.
PostgreSQL 19 adds IGNORE NULLS/RESPECT NULLS options to window functions like LAG and FIRST_VALUE, improving data handling.
PostgreSQL 19 introduces GROUP BY ALL, a new SQL feature that automatically groups by all non-aggregate columns, simplifying queries.
Introduces vtime, a custom command-line utility for tracking and displaying elapsed time of long-running processes in real-time.
PostgreSQL 19 adds new random() functions for generating random dates and timestamps, useful for creating test data.
A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
Explains a new PostgreSQL 19 feature that displays Memoize planner estimates in EXPLAIN output to help debug query plan choices.
Benchmarking pg_dump performance across PostgreSQL versions 10-18, revealing speed changes and regression in recent versions.
PostgreSQL 18 adds a function to retrieve detailed memory context statistics from any backend or auxiliary process for debugging memory issues.
PostgreSQL 18 introduces NOT VALID for NOT NULL constraints, allowing addition without table scans and validation with reduced locking.
PostgreSQL 18 adds modern SHA-256 and SHA-512 password hashing algorithms to the pgcrypto extension, enhancing security.
PostgreSQL 18 introduces new non-text dump formats for pg_dumpall and pg_restore, improving performance and flexibility for database backups.
PostgreSQL 18 adds a new parameter to json{b}_strip_nulls functions to also remove null elements from arrays, enhancing JSON data cleaning.
PostgreSQL 18 will introduce parallel CREATE INDEX for GIN indexes, significantly speeding up index builds on large tables.
PostgreSQL 18 will improve EXPLAIN output by showing fractional row counts with two decimal digits for better query plan accuracy.
Explains the new virtual generated columns feature in PostgreSQL 18, detailing its syntax, behavior, and current limitations.
PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.
