O'Reilly logo

PostgreSQL Cookbook by Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing partitioning

Here, we are going to cover table partitioning and show the steps that need to be performed in order to partition a table.

Getting ready

Exposure to database design and normalization is the only requirement.

How to do it...

The following series of steps need to be carried out in order to set up table partitioning:

  1. First, create a master table with all the 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 for a master table; however, since there are performance benefits of using an index, we will create an index from a performance perspective here:
    CREATE TABLE country_log ( created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), country_code ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required