Compares Oracle and PostgreSQL wait analysis for database performance tuning, focusing on wait classes vs. event types.
A guide for Oracle DBAs on PostgreSQL query tuning, covering the pg_stat_statements extension and the PostgreSQL planner's cost model.
A guide for Oracle DBAs on PostgreSQL transaction control, locking mechanisms, and performance monitoring basics.
A technical comparison of PostgreSQL and Oracle physical storage, memory architecture, and processes for database administrators transitioning between the two systems.
A talk at PyCon Italia 2025 on implementing semantic search using Python, Django, PostgreSQL, and open-source AI tools.
Benchmarking pg_dump performance across PostgreSQL versions 10-18, revealing speed changes and regression in recent versions.
A technical guide on using heaptrack to debug memory leaks in PostgreSQL, with examples of introducing and detecting leaks in C code.
A technical guide for upgrading PostgreSQL from version 16 to 17 on Ubuntu 25.04, including commands and verification steps.
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.
A developer details migrating a Fitbit data app from Google Cloud to a self-hosted EU VPS, covering PostgreSQL, nginx, and CI/CD with GitHub Actions.
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.
A technical guide demonstrating how to perform a minimal-downtime major version upgrade of a PostgreSQL cluster using EDB Postgres Distributed.
PostgreSQL 18 adds delay time logging to VACUUM/ANALYZE VERBOSE and autovacuum logs, aiding performance monitoring.
A developer shares their 10-year journey from web development to specializing in database engineering, focusing on Postgres and distributed systems.
