PostgreSQL partition table partition range

Conclusion: When partition table is created, the range definition is left closed and right open.

Create partition table

create table orders
(
    id          bigint,
    create_time timestamp(0) default current_timestamp
) partition by range (id);

Creating a default partition

When inserted data does not match the subpartitions, it is added to the default partition.

create table def partition of orders default;

Create subpartition

create table orders_1 partition of orders for values from (1) to (10);
create table orders_2 partition of orders for values from (10) to (20);

Insert data

Test 1:

insert into orders(id) values (10);

Recorded in the orders_2 subpartition.

Test 2:

insert into orders(id) values (20);

Record in the DEF default partition.