Video není dostupné.
Omlouváme se.
Simple trick to make your queries WAY more efficient // Partial Indexes
Vložit
- čas přidán 4. 08. 2024
- 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
I love these index video series! Learning so much in each video!
Can you make a video which covers pagination using Supabase API. It will be really helpful
Dude you are the man, much appreciated!
Amazing 🔥🔥
does it automatically update index if user is activated or deactivated? new user added etc?
yes, indexes exist on a column+table level, so Postgre updates the index automatically on data mutations
@@poolkrooni thank you