Indexing can greatly improve the performance of database queries over a large dataset. Postgres supports Indexing multiple columns, which can be more performant and space efficient, than multiple singlecolumn Indexes. In this video, Jon Meyers demonstrates how to create a Multicolumn Index and discusses some of the design considerations and tradeoffs that need to be made.

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

00:00 An inefficient query
01:00 Improving performance by not overfetching data
02:03 Singlecolumn Indexes to reduce query time
04:21 An extremely inefficient query using an Index
06:08 Designing a Multicolumn Index to satisfy multiple queries
07:22 The sequence of columns is important in MultiColumn Indexes
09:46 Which is more space efficient?
10:53 Maybe a single Covering Index would be better

Videos to watch next:
▶ Make your queries 43,240x faster:    • Make your queries 43,240x faster  
▶ The FASTEST possible way to query data:    • The FASTEST possible way to query data  
▶ 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