Lectures

Learn how to efficiently index JSONB fields in PostgreSQL using GIN and BTREE indexes. This article covers the features, advantages, creation examples, and common mistakes when working with these indexes.

Learn how to seriously speed up searching arrays in PostgreSQL using the `@>`, `<@`, and `&&` operators and GIN indexes. Real-life examples, optimization tips, and common mistakes — everything you need for blazing-fast array queries in your database.

Too much indexing can actually slow down your database and waste resources for no good reason. In this material, you'll learn how to spot unnecessary indexes, why you should avoid them, and how to keep the right balance between search speed and efficient data updates.

Learn how to pick the right index type for different PostgreSQL scenarios: comparing B-TREE, GIN, GiST, and other indexes, real-life examples, tips, and common mistakes.

Indexes in PostgreSQL are a powerful tool for speeding up queries, but using them the wrong way can actually tank your performance and waste resources. In this article, we’ll check out common mistakes when working with indexes, learn how to avoid them, and go through some practical optimization tips.