Author: Alexandr Shelemetyev

Since Alexandr was a child, he has been interested in information technologies and has developed simple programs. As time went on, he started to be interested in databases. Alexander got a lot of valuable experience: he developed databases, came up with calculation algorithms, passed data, performed information system integration and was engaged in system administration. Thanks to his experience, Alexander also owned his enterprise.

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3

13:08 Database administation, Perfomance Tuning

I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of...
Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 2

22:58 Database development, Statements

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

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 1

09:19 Database development, Statements

  Why does it take so much time to execute a query? Why are there no indexes? Chances are you’ve heard about EXPLAIN in...
Read More

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

16:27 Database development, Triggers

When designing large relational databases, we often make a decision to diverge from a normal form,...
Read More
Close