Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3
4.5 (90%) 2 votes

I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of Understanding EXPLAIN by Guillaume Lelarge.
To better understand the issue, I highly recommend reviewing the original “Understanding EXPLAIN” by Guillaume Lelarge and read my first and second articles.

Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2
5 (100%) 2 votes

In my previous article, we started to describe the basics of the EXPLAIN command and analyzed what happens in PostgreSQL when executing a query.

I am going to continue writing about the basics of EXPLAIN in PostgreSQL. The information is a short review of Understanding EXPLAIN by Guillaume Lelarge. I highly recommend reading the original since some information is missed out.

Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1
4 (80%) 2 votes

 

Why does it take so much time to execute a query? Why are there no indexes? Chances are you’ve heard about EXPLAIN in PostgreSQL. However, there are still many people who have no idea how to use it. I hope this article will help users tackle with this great tool.

This article is the author revision of Understanding EXPLAIN by Guillaume Lelarge. Since I have missed out some information, I highly recommend you get acquainted with the original.

Read More

Don’t like database triggers? You just don’t know how to work with them!

Don’t like database triggers? You just don’t know how to work with them!
Rate this post

When designing large relational databases, we often make a decision to diverge from a normal form, i.e. denormalization.

The reasons for this can be different, such as an attempt to speed up access to the specified data, constraints of the used platform/framework/development tools, and lack of skills of a database developer/designer.

Read More