O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, 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

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

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