Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3
I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2
In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1
Why does it take so much time to execute a query? Why are there no indexes? Chances are you’ve heard about EXPLAIN in...
Don’t like database triggers? You just don’t know how to work with them!
When designing large relational databases, we often make a decision to diverge from a normal form,...
