ViewTube

From the archives of our internal Postgres hack week. Learn table storage and indexes in Postgres vs MySQL. Head to ...

How To Create Index In PostgreSQL? Have you ever wondered how to improve the performance of your PostgreSQL database?

GiST index in PostgreSQL - how does it work internally and what are its advantages and disadvantages? How is it used with ...

The difference between PostgreSQL indexes, pros and cons of using different types.

Learn about database indexing, including why they're essential, when to use them, and a few different types of indexes that are ...

_ Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from ...

In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to ...

Quickly learn PostgreSQL JSONB: query inside documents, turn arrays into rows, and speed up searches with indexes on JSONB ...

Session Title: Rules of Indexing in PostgreSQL Speaker(s): Alan Zakrzewski Track: Ops Session Description This session delivers ...

Presentation by: Alain LESAGE (DALIBO) 📕 Summary: Relational database management systems aren't magic and their primary ...

In this video, I'll compare GIN and GiST indexes for full-text search. I'll show you how they work and explain the differences in ...

Welcome back to Dev Portal In this tutorial, we're unlocking one of the most powerful performance optimizations technique in ...

This talk will discuss about: the main limitations is that unique keys must include the partition key, which can be restrictive for many ...

PostgreSQL: Hash index. We'll see how it works under the hood and understand if it's better than B tree index. So, what is a hash ...

In this video, I'm showing you what options you have to index JSON columns when using PostgreSQL. I explain how to index ...

When looking for ways to speed up queries for your application, one of the best places to start is to add indexes that cover ...

Video of a conference talk exploring the numerous advantages document databases have for developers due to their flexibility ...

Dive into the world of bitmap indexes and discover how they revolutionize database filtering! This video provides a ...

Presented by Gary Evans and Nishchay Kothari at PGConf.dev 2025 (https://2025.pgconf.dev) Traditional indexing structures, ...

... serve many more reads than writes i think you should add an index on customer ID and order status adding an index will greatly ...