Yes! Please do a video on partitioning a table with no down time. This recent Postgres series of content has been a goldmine of knowledge that’s either hidden in the docs, or locked in somebody’s head somewhere because they got the experience but never shared it.
It’s worth bearing in mind that it’s not feasible for Supabase to document or teach us about all of these features. They are not Supabase features; they are PostgreSQL features, and PostgreSQL has been around for decades. It’s all documented on the PostgreSQL site, with thousands of tutorials all over the Internet.
This series is genuinely the only thing a backend beginner ever needs to work with databases. If this was marketed like a paid course I would pay hundreds of dollars for this whole thing. Can't believe it's free and doesn't even have that many views.
Absolutely brilliant video! So helpful! Definitely going to do this in my Supabase project and am so keen to check out Partman (video on that please!) And would love to see how to do it without downtime too!
Thanks! Glad you enjoyed it! I would say reach for an index pretty early, and then look at partitioning when your indexes slow down, assuming you have easily partitionable data 👍
They do not get automatically partitioned. Usually the referenced table does not grow at the same rate, but you could also partition that table if it gets too big 👍
@@JonMeyers then why dont u guys add this feature where it can partition the referenced table or automatice partition ? and yes i saw pgpartman but theres no tutorial or anything on how to use it properly like you do (yes i am a noob programer )
Yes! Please do a video on partitioning a table with no down time. This recent Postgres series of content has been a goldmine of knowledge that’s either hidden in the docs, or locked in somebody’s head somewhere because they got the experience but never shared it.
It’s worth bearing in mind that it’s not feasible for Supabase to document or teach us about all of these features. They are not Supabase features; they are PostgreSQL features, and PostgreSQL has been around for decades. It’s all documented on the PostgreSQL site, with thousands of tutorials all over the Internet.
Excellent! Will add it to the list! 👍
I hope this series never ends.
Thanks! Glad you’re enjoying the series! 🙌
This series is genuinely the only thing a backend beginner ever needs to work with databases. If this was marketed like a paid course I would pay hundreds of dollars for this whole thing. Can't believe it's free and doesn't even have that many views.
you're an underated content creator have learnt a ton about relational dbs from your vids!
Glad to hear that! What would you like to see next?
table partitioning in postgres is a superpower! handy for datawarehouses too.
Totally! Surprisingly easy to implement for how much this can help the performance of your database!
Didn't know this was a thing, awesome video!
Absolutely brilliant video! So helpful! Definitely going to do this in my Supabase project and am so keen to check out Partman (video on that please!)
And would love to see how to do it without downtime too!
Awesome! Will add both of those to the list 👍
Please make a video showing how to use pg_partman, every SaaS app would use partitioning if it’s automated.
Will add it to the list! 👍
Very helpful! Thank you
Glad to hear it! 🙌
Amazing 🔥 I like Supabase 🔥🔥
Same! Glad you enjoyed the video! 🙌
Yes… please do a video on partitions and spend a little time explaining how we would use the api call in the likes of Flutterflow.
Will add it to the list 👍
When would you recommend to use either index or partition?
Another great video by the way 😉
Thanks! Glad you enjoyed it!
I would say reach for an index pretty early, and then look at partitioning when your indexes slow down, assuming you have easily partitionable data 👍
How do you update in live your partitions when you have new data (in your people table for example here)?
You can either create a catch-all partition as “default” or use an extension like pg_partman
The MANGOS LOL
The best companies!
and what about the referenced tables? do they also get automatically partitioned or not
They do not get automatically partitioned. Usually the referenced table does not grow at the same rate, but you could also partition that table if it gets too big 👍
@@JonMeyers then why dont u guys add this feature where it can partition the referenced table or automatice partition ?
and yes i saw pgpartman but theres no tutorial or anything on how to use it properly like you do (yes i am a noob programer )
Postgres 1
Supabase 0
Not sure what that means, but every point for Postgres is also a point for Supabase 🤝