Simple trick to make your queries WAY more efficient // Partial Indexes

Partial Indexes can drastically increase the performance of your PostgreSQL database queries by reducing the irrelevant data duplicated in the Index. In this video, Jon Meyers demonstrates how to use a `where` clause to specify which rows of data should be indexed.

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

Unlike traditional PostgreSQL Indexes that duplicate entire tables, Partial Indexes contain only a subset of the data that matches a `where` condition. This reduces the amount of time it takes Postgres to find data and minimizes the amount of disk space used by the Index.

00:00 How is a Partial Index different to a regular Index?
00:31 A very inefficient query
01:36 Creating a basic Index
02:21 Excluding irrelevant data with Partial Index
03:30 Reusing this Index across queries
04:04 Are Partial Indexes smaller than traditional Indexes?
05:01 Something to not do with Partial Indexes!
06:12 Segmenting data with Table Partitions

💻 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  
▶ Are Multi-Column Indexes a good idea:    • Are Multi-Column Indexes a good idea?  

👇 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