In this recipe we are going to cover table partitioning and show the steps that are needed to partition a table.
Exposure to database design and normalization is needed.
There are a series of steps that need to be carried out to set up table partitioning. Here are the steps:
- The first step is to create a master table with all fields. A master table is the table that will be used as a base to partition data into other tables, that is, partitions. An index is optional here for a master table; however, since there are performance benefits of using an index, we are creating an index from a performance perspective:
CREATE TABLE country_log ( created_at TIMESTAMP WITH TIME ZONE DEFAULT ...