In previous articles we discussed how the system plans a query execution and how it collects statistics to select the best plan. The following articles, starting with this one, will focus on what a plan actually is, what it consists of and how it is executed. In this article, I will demonstrate how the planner calculates execution costs. I will also discuss access methods and how they affect these costs, and use the sequential scan method as an illustration. Lastly, I will talk about parallel...| postgrespro.com
Hello! I'm kicking off another article series about the internals of PostgreSQL. This one will focus on query planning and execution mechanics. This series will cover: query execution stages (this article), statistics, sequential and index scans, nested-loop, hash, and merge joins. Many thanks to Alexander Meleshko for the translation of this series into English. This article borrows from our course QPT Query Optimization (available in English soon), but focuses mostly on the internal mechani...| postgrespro.com
So far we've discussed query execution stages , statistics , and the two basic data access methods: Sequential scan and Index scan . The next item on the list is join methods. This article will remind you what logical join types are out there, and then discuss one of three physical join methods, the Nested loop join. Additionally, we will check out the row memoization feature introduced in PostgreSQL 14. Joins Joins are the primary feature of SQL, the foundation that enables its power and agi...| postgrespro.com