High Performance PostgreSQL for Rails

Let’s Split

It’s time to reflect on what you’ve accomplished in this chapter and then look toward the next one.

You learned all about declarative table partitioning in PostgreSQL—what, when, and how to use it. You worked through a concrete use case using Rideshare trip positions data and migrated it into a partitioned table structure using the pgslice tool.

With sufficient planning and testing, for an append-only table, pgslice helps you achieve zero downtime online data migration. With a partition table in place, you’re well-positioned to archive unneeded data from your database as a nonblocking operation.

You briefly looked at other partitioning types, filling out your basic knowledge of all three supported types. You explored the benefits ...