🔥The 9th Round of Easy Loan, Earn $40 Reward is in progress❗️ ⏰ Promotion Period: January 15th - Feburary 15th, 2025 👉 Register now and check more details at gate.io/campaigns/358

PostgreSQL hash index performance cybertec-postgresql.com/en/postgresql-…

When is a secondary index-only query not index-only for InnoDB and Postgres? In PostgreSQL it is well-know that even Index-Only Scan can have "Heap Fetches". For InnoDB it is hardly known and not visible at all. smalldatum.blogspot.com/2022/08/when-i…

New episode: "Modern SQL" Michael is joined by Markus Winand, creator of use-the-index-luke.com and modern-sql.com, to discuss Modern SQL — what it means, why it matters, and a phrase that should be on a t-shirt. 🎧 postgres.fm/episodes/moder… 📺 youtu.be/mGqqQg-dG-w

This is one of these very few articles: short, relevant, clear. A MUST read for everybody—whether using PostgreSQL or not. It is generally good to see how these things work. Thank you David Rowley — for the patches too, of course! citusdata.com/blog/2024/02/0…

Recent blog post from David Rowley from the Postgres team at Microsoft, which developers & users loved 💟 All about what's new 🤯 in the #PostgreSQL 16 query planner As SQL Performance Tips says, it's "short, relevant, clear. A MUST read for everybody" techcommunity.microsoft.com/t5/azure-datab…

too many indexes

I started a blog post on this a long time ago but never finished. A recent mention on #determinism in the context of query optimisation sort of hit the nerve. Determinism is so important but underrated and often ignored. So let's throw out a quick 🧵: x.com/julianhyde/sta…

The Oracle DB maintains some information either on block or on row level ([NO]ROWDEPENDENCIES). dbaora.com/ora_rowscn-nor… The default (NOROWDEPENDENCIES) may cause ORA-08177: can't serialize access for this transaction even if there is no problem on row level.

Just announced new training dates. There are still seats left in my next performance training in April. The remaining courses take place in fall. winand.at/sql-training/o…

Have finished reading the "SQL performance explained" book from Markus Winand (creator of the use-the-index-luke.com). Have already known about indexes and B-trees, but the book helped to understand how they affect SQL operations under the hood. Highly recommend!

There is currently some fuzz about the performance of subqueries vs with clause. Here is my take on it: modern-sql.com/feature/with/p…

The WITH clause is useful to write readable SQL. modern-sql.com/use-case/liter…

Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th! winand.at/en/newsletter/…

In the meanwhile enjoy a discount for SQL Performance Explained if you don't have it yet: 15YrsAnniversary Only valid when purchasing directly from me (not on Amazon, ...): sql-performance-explained.com (but valid for all languages — see language selection at the top).

TIL about Index-Only Scan for databases ✨ Also I'm in love with this website use-the-index-luke.com/sql/clustering…

SQL Best Practices Every Java Engineer Must Know foojay.io/today/sql-best… [IMHO: not just Java Engineers]