create_table.sql

application/octet-stream

Filename: create_table.sql

Type: application/octet-stream

Part: 0

Message: Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager

create table test (a int, b text) partition by range (a);
CREATE TABLE part1 partition of test for values from (0) to (1000);
CREATE TABLE part2 partition of test for values from (1000) to (2000);
CREATE TABLE part3 partition of test for values from (2000) to (3000);
CREATE TABLE part4 partition of test for values from (3000) to (4000);
CREATE TABLE part5 partition of test for values from (4000) to (5000);
CREATE TABLE part6 partition of test for values from (5000) to (6000);
CREATE TABLE part7 partition of test for values from (6000) to (7000);
CREATE TABLE part8 partition of test for values from (7000) to (8000);
CREATE TABLE part9 partition of test for values from (8000) to (9000);
CREATE TABLE part10 partition of test for values from (9000) to (10000);
CREATE TABLE part11 partition of test for values from (10000) to (11000);
CREATE TABLE part12 partition of test for values from (11000) to (12000);
CREATE TABLE default_part partition of test for values from (12000) to (999999999);