May 14, 2024, 7:42 p.m. | Dmitry Romanoff

DEV Community dev.to

When we talk about databases, a very interesting aspect is understanding how the optimizer chooses the execution plan for queries.


Many readers ask me to talk about this.


In this blog, I want to demonstrate how the size of tables and the presence of indexes affect the PostgreSQL optimizer’s choice of method when joining tables. I will consider several scenarios when joining two tables in PostgreSQL. I will vary the sizes of the tables and the presence of an index, …

blog database databases devops performance postgres postgresql queries readers tables talk understanding

Doctoral Researcher (m/f/div) in Automated Processing of Bioimages

@ Leibniz Institute for Natural Product Research and Infection Biology (Leibniz-HKI) | Jena

Seeking Developers and Engineers for AI T-Shirt Generator Project

@ Chevon Hicks | Remote

Software Engineer for AI Training Data (School Specific)

@ G2i Inc | Remote

Software Engineer for AI Training Data (Python)

@ G2i Inc | Remote

Software Engineer for AI Training Data (Tier 2)

@ G2i Inc | Remote

Data Quality Intern

@ Syngenta Group | Toronto, Ontario, Canada