PostgreSQL

Understanding Upstream vs. Downstream PostgreSQL

10/13/2025 / By / PostgreSQL / Leave a Comment

When you install PostgreSQL on a Raspberry Pi or on your favorite Linux distribution, the very first surprise often comes right after the installation finishes: the configuration files are not where the official documentation says they should be. Instead of finding postgresql.conf inside the data directory, you discover that Debian places it under /etc/postgresql/<version>/<cluster>/. To make sense of …

Understanding Upstream vs. Downstream PostgreSQL + read more

Introducing my new PostgreSQL Quickies Series on YouTube

09/15/2025 / By / PostgreSQL, PostgreSQL Quickies / Leave a Comment

For many years I have been publishing my SQL Server Quickies – short, focused videos that explain specific database topics in just a few minutes. These quick sessions have helped countless developers and DBAs to sharpen their skills without the need to spend hours in front of lengthy tutorials. Now it’s time to expand this concept into …

Introducing my new PostgreSQL Quickies Series on YouTube + read more

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL

09/08/2025 / By / PostgreSQL, SQLServer / Leave a Comment

Last Thursday I had the chance to attend the PGDay Austria conference, and it turned out to be one of the most inspiring community events I’ve been to in a long time. Not only did I listen to great talks about PostgreSQL internals, I also gave my very first lightning talk – nervously stepping on stage …

Column Tetris Explained: The Hidden Storage Costs of Migrating from SQL Server to PostgreSQL + read more

Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose

09/08/2025 / By / PostgreSQL / Leave a Comment

PostgreSQL is a powerful, feature-rich database system, but its architecture differs in significant ways from Microsoft SQL Server. One of the most important differences lies in how connections are handled. While SQL Server multiplexes many client requests across worker threads inside a single process, PostgreSQL spawns a dedicated backend process for every client connection. This …

Running PostgreSQL with PgBouncer on Mac OS Using Docker Compose + read more

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.