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

Managing partitions

In this recipe, we are going to show how the partitioning scheme remains intact when an existing partition is dropped or a new partition is added.

Getting ready

Refer to the first recipe, Implementing partitioning, before reading the steps outlined in this recipe.

How to do it...

There are two scenarios here. One is what happens when an existing partition is deleted and the other is what happens when a new partition is added. Let's discuss both cases:

  1. In the first scenario we will drop an existing partition table. Here it is the country_code_sa table that will be dropped:

    Before dropping the country_log_sa child table, first see the records in the country_log master table:

             postgres=# SELECT * from country_log;          created_at ...

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