Postgres scales … when you do this!

Partitioning Tables can greatly improve the efficiency of your Postgres queries by drastically reducing the size of the result set being processed. In this video, Jon Meyers demonstrates how to refactor a giant multi-tenant table into much smaller, individual partitions.

Table partitioning in Postgres is a powerful database feature that allows large tables to be divided into smaller, more manageable pieces called partitions. Each partition can be accessed and managed independently, improving query performance and simplifying maintenance. Partitions can be created based on various criteria, such as range, list, or hash, enabling efficient organization of data. By filtering queries to search within specific partitions, database operations become faster and more efficient. This technique is particularly useful for handling large datasets, optimizing resource usage, and enhancing overall database performance.

00:00 When you need Table Partitions
02:19 Creating a Partitioned Table by List of values
03:39 Creating Partitions for each unique value
04:42 Querying partitioned tables
06:21 Maintaining partitions as data changes
08:36 Querying across multiple partitions
09:18 Combining Indexes with Partitioned Tables

💻 Videos to watch next:

👇 Learn more about Supabase 👇

📱 Connect with Us:

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

[wembleyleach]

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.

[MrZiyak]

you're an underated content creator have learnt a ton about relational dbs from your vids!

[timondalton]

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.

[mrrolandlawrence]

table partitioning in postgres is a superpower! handy for datawarehouses too.

[DetectiveMichealScarn]

Didn't know this was a thing, awesome video!

[tristdrum]

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!

[luisandrade]

Please make a video showing how to use pg_partman, every SaaS app would use partitioning if it’s automated.

[markh-thai]

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.

[me-jh]

How do you update in live your partitions when you have new data (in your people table for example here)?

[karzia]

wow.. it's good solution for me.
thankx

[thibault]

When would you recommend to use either index or partition?
Another great video by the way 😉

[rahul_ji]

and what about the referenced tables? do they also get automatically partitioned or not