Indexes can greatly improve the performance of a Postgres database, especially as the size of the tables grow. In this video, Jon Meyers demonstrates how to create an index for a particular column, and use explain analyze to measure the optimization.

Managing Indexes in Postgres: https://supabase.com/docs/guides/data...

By default, Postgres creates a BTree index, which makes filtering result sets incredibly performant. The index stores a copy of the column's value, as well as a pointer to the full row, in case the query requires additional data.

00:00 Make your queries 43,240x faster
01:04 A very slow Select query (without index)
02:39 Create an Index
03:09 A super fast Select query (with index)
05:24 Selecting an Index Postgres Query Planner
07:55 Does the order of where statements matter?
10:28 What happens if multiple indexes are available?
12:13 Why not index every column?

Videos to watch next:
▶ 8 things you should NEVER do in a Database:    • 8 things you should NEVER do in a Dat...  
▶ FASTEST way to host a Postgres database (2024):    • FASTEST way to host a Postgres databa...  
▶ Learn Postgres (playlist):    • Learn Postgres  

Learn more about Supabase

Website: https://supabase.com/
Get started: https://app.supabase.com/
Docs: https://supabase.com/docs

Subscribe for more tutorials and feature updates from Supabase:    / @supabase  

Connect with Us:
Github: https://www.github.com/supabase
Discord: https://discord.supabase.com/
Twitter:   / supabase  
▶ Instagram (follow for memes):   / supabasecom  


ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.

Build in a weekend, scale to millions.

#Supabase #AppDevelopment #RealtimeApps #DeveloperTools