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 ...

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

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

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

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

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 ...

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

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 ...

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

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

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

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

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

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

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

Most tables have a lot of data we rarely query, and indexing only the rows that matter can dramatically boost performance.