Estimating Growth of Time-Oriented Data
PostgreSQL Declarative Partitioning offers several partitioning types to choose from. The types are related to both how you’ll divide up and store the data and also, equally important, how you’ll access the data. Besides how you’ll divide up the data being stored, consider how it will grow over time.
You’re now ready to jump into a concrete example.
Take a look at the trip_positions table in Rideshare. In the main branch, this is a regular PostgreSQL table that’s not partitioned. In upcoming sections, you’ll explore whether it makes sense to partition this table.
As discussed earlier, take a look at the data types being stored, how frequently rows are inserted, and what your growth projections are for ...
Get High Performance PostgreSQL for Rails now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
