Amazing explainer for something so basic as indexes. I'm always surprised how can people learn this so late. If there's another video I would recommend going into multiple column indexes too.
@dshukertjr4 ай бұрын
Loving the quote at the end!
@aLfRemArShMeLlOw4 ай бұрын
42069x faster
@JonMeyers4 ай бұрын
Missed opportunity! 😂
@TheBlackManMythLegend4 ай бұрын
I used to work at EDF (electricite de France ) and we performed for PL/SQL script to update the 40 millions of line of customer to make the database faster. Kinda forgot about all of that. But that was satisfying to do.
@mabud_alam4 ай бұрын
Please explain how the pgvector index works
@harryzachariou14 ай бұрын
Fantastic video!
@sire_ns4 ай бұрын
Incredible! thanks
@todoku13 ай бұрын
maybe a noob question but does the advantage of the postgres query planner also work when I use it from the client side like in flutter? like in 08:05
@roninspect43574 ай бұрын
will this index will work with iLike queries?
@GivSadds4 ай бұрын
I left you database service , just because you don't have the query rows count features for the application codes . You have only in SQL but not in dart , javascript or any other languages
@KieranCrown4 ай бұрын
You can utilise DB triggers and functions to update the count and query it in the frontend with ease
@Supabase4 ай бұрын
You can get the row count using the count option: supabase.com/docs/reference/javascript/select Also we have count() aggregate function option for counting rows of a referenced table: supabase.com/blog/postgrest-aggregate-functions#the-basics-of-aggregate-functions
@heyjitendra4 ай бұрын
Thanks excited to know more about Indexes.
@tasfiqjawaad37574 ай бұрын
When I tried to index a table, it did improve the query time, but only by a couple of seconds. It was noticeable but not as much as in this video. Does it have anything to do with my supabase plan? I'm using the free tier.
@poolkrooni3 ай бұрын
How big is your dataset? In the video he's dealing with 10M entries
@sumitpurohit88494 ай бұрын
Can you please update the docs for when to use which distance operator in HNSW and IVFFlat vector indexes. Currently it is unclear weather to use cosine distance, Euclidean distance or negative inner product. Also I would love to have detailed videos/blogs/docs on which embedding model to use for how many words(tokens) of data and also on hybrid search as well.
@Dom-zy1qy4 ай бұрын
Tbh this isn't really something you should be looking at the supabase documentation for.
@laugedyret4 ай бұрын
Nice, thanks!
@JonMeyers4 ай бұрын
Glad you enjoyed it! 🙌
@damnnn.2 ай бұрын
SUPABASE is AWESOME. The Dev Team is teaching the product, how it should be. I am new to Supabase and these videos are very useful for me. If it's not important to you, try being overwhelmed with textwall documentations and useless videos.
@activenode4 ай бұрын
Nice one jon!
@vincentjohnflorio4 ай бұрын
Perfectly explained!
@TheBlackManMythLegend4 ай бұрын
very didactic
@PramodGeorge4 ай бұрын
Hot Damn!
@althafhussain97184 ай бұрын
In this video, the Explain Analyze tool reported a duration of 3 ms for the first query with username and is_active, and 0.02 ms for the second query with is_active and username. Can you explain why there is such a difference?
@tylerhartman16304 ай бұрын
I would guess that either the machine is running multiple threads and the thread got swapped to inactive for 1 ms or that it cached the result from the first one, so it already knew the answer for the second one (because it processed it as the same query)