Published On Jun 14, 2024
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 single-column Indexes. In this video, Jon Meyers demonstrates how to create a Multi-column 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 over-fetching data
02:03 Single-column Indexes to reduce query time
04:21 An extremely inefficient query using an Index
06:08 Designing a Multi-column Index to satisfy multiple queries
07:22 The sequence of columns is important in Multi-Column 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