PostgreSQL

When it comes to database performance, query execution planning is one of the most critical factors. Every time a database receives a query, it must decide how to execute it in the most efficient way possible. This decision making process – known as query planning – can be expensive in terms of computation time, especially …

Understanding Query Plan Caching in PostgreSQL and How It Differs from SQL Server + read more

When it comes to fine-tuning database performance, small settings often make a big difference. One such setting – frequently discussed but not always fully understood—is the fill factor. Both SQL Server and PostgreSQL support this concept, yet they approach it differently. If you’re managing databases in either of these systems, understanding how fill factor works can …

Understanding Fill Factor in SQL Server and PostgreSQL + read more

Are you a seasoned SQL Server professional looking to broaden your horizons and step into the world of PostgreSQL? Do you want to leverage your existing SQL Server expertise while mastering the unique features of PostgreSQL? If so, I’ve got exciting news for you! I’m thrilled to announce the release of my brand-new, two-day online …

Introducing My Brand-New Online Training: PostgreSQL for the SQL Server Professional! + read more