Implementing partitioning

In this recipe we are going to cover table partitioning and show the steps that are needed to partition a table.

Getting ready

Exposure to database design and normalization is needed.

How to do it...

There are a series of steps that need to be carried out to set up table partitioning. Here are the steps:

  1. 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 ...

Get PostgreSQL High Performance Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.