SQLpassion

Today, I’m excited to announce the lineup for my upcoming SQLpassion online trainings for the next 6 months, featuring several brand-new trainings I’ve been developing over the past few months: https://www.sqlpassion.at/live-trainings/

If you come from a SQL Server background (like in my case), you already have strong instincts about indexing. You know why B-trees dominate, why sorted structures matter, and why equality predicates are usually fast enough without special tricks. When you first encounter Hash Indexes in PostgreSQL, the obvious question is not how they work, but why they exist at all.

👉 Read more: https://www.SQLpassion.at/archive/2025/12/22/hash-indexes-in-postgresql/

Hash Indexes in PostgreSQL – SQLpassion If you come from a SQL Server background (like in my case), you already have strong instincts about indexing. You know why B-trees dominate, why sorted structures matter, and why equality predicates are usually fast enough without special tricks. When you first encounter Hash Indexes in PostgreSQL,....

In November, I delivered a webcast titled “PostgreSQL Introduction for the SQL Server Professional” – a compact introduction to the most important architectural and conceptual differences between SQL Server and PostgreSQL.

👉 You can find here now the recorded version of the webcast: https://www.youtube.com/watch?v=uK5FjVmAIpk

SQLpassion Webcast, November 2025: PostgreSQL Introduction In this webcast I introduce PostgreSQL.