A technical analysis of a SQL interview question about detecting suspicious account logins from multiple countries within a short timeframe.
A guide to setting up asynchronous PostgreSQL operations with SQLModel and FastAPI, including code examples for async engines and sessions.
A technical guide on setting up a single-node EDB Postgres Distributed (PGD) cluster on Ubuntu, including installation and verification steps.
Explains the difference between confirmed_flush_lsn and restart_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Explains the difference between restart_lsn and confirmed_flush_lsn in PostgreSQL replication slots for troubleshooting and optimization.
Explains a new PostgreSQL 19 feature that displays Memoize planner estimates in EXPLAIN output to help debug query plan choices.
A tutorial on automating PostgreSQL performance debugging in Rails using LLMs and the Model Context Protocol (MCP) with a Slack bot interface.
Compares PostgreSQL's tuple-based MVCC and append-only updates with Oracle's in-place row updates and undo-based MVCC for database concurrency.
A talk on implementing semantic search in a web service using Python, Django, PostgreSQL, and open-source AI tools, presented at EuroPython 2025.
Best practices for managing PostgreSQL replication slots to prevent WAL bloat and ensure reliable CDC pipelines in production.
Best practices for managing PostgreSQL replication slots to prevent WAL bloat and ensure reliable CDC pipelines in production.
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.
