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: 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,2...
▶ The FASTEST possible way to query data: • The FASTEST possible w...
▶ Are Multi-Column Indexes a good idea: • Are Multi-Column Index...
👇 Learn more about Supabase 👇
🕸 Website: supabase.com/
🏁 Get started: app.supabase.com/
📄 Docs: supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: www.github.com/supabase
💬 Discord: www.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

[@dshukertjr]

I love these index video series! Learning so much in each video!

[@sunfarmfoods6361]

Can you make a video which covers pagination using Supabase API. It will be really helpful

[@caseyspaulding]

Dude you are the man, much appreciated!

[@eliuddyn]

Amazing 🔥🔥

[@Yusuf-ok5rk]

does it automatically update index if user is activated or deactivated? new user added etc?

[@poolkrooni]

yes, indexes exist on a column+table level, so Postgre updates the index automatically on data mutations

[@Yusuf-ok5rk]

@@poolkrooni thank you