Slide 34
Slide 34 text
postgres=# CREATE DATABASE partition_test;
CREATE DATABASE
postgres=# \c partition_test
You are now connected to database "partition_test" as user "postgres".
partition_test=# CREATE TABLE log_record (
partition_test(# log_id SERIAL NOT NULL,
partition_test(# log_datetime TIMESTAMP NOT NULL,
partition_test(# log_text VARCHAR(500) NOT NULL
partition_test(# )
partition_test-# PARTITION BY RANGE (log_datetime);
CREATE TABLE
partition_test=# CREATE TABLE log_record_default PARTITION OF log_record DEFAULT;
CREATE TABLE
partition_test=# CREATE TABLE log_record_2015 PARTITION OF log_record
partition_test-# FOR VALUES FROM ('2015-01-01 00:00:00') TO ('2016-01-01 00:00:00');
CREATE TABLE
テーブルパーティショニングで性能向上(3/9)
34