18 • 単一の SQL 文を複数のプロセスで並列に処理を行う Application Big Table SQL Backend process bgworker: parallel worker for PID {pid} postgres: {user} {dbname} … Worker process Worker process Worker process
postgres=> CREATE TABLE measurement (city_id int not null, logdate date not null,unitsales int) PARTITION BY RANGE (logdate); CREATE TABLE postgres=> CREATE TABLE measurement_y2006m02 PARTITION OF measurement FOR VALUES FROM ('2006-02-01') TO ('2006-03-01'); CREATE TABLE postgres=> CREATE TABLE measurement_y2007m11 PARTITION OF measurement FOR VALUES FROM ('2007-11-01') TO ('2007-12-01'); CREATE TABLE … postgres=> EXPLAIN SELECT * FROM measurement WHERE logdate = '2007-12-01'; QUERY PLAN ---------------------------------------------------------------------- Seq Scan on measurement_y2007m12 (cost=0.00..33.12 rows=9 width=16) Filter: (logdate = '2007-12-01'::date) (2 rows)
LP 29 複数のパーティションを単一のパーティションにマージ LIST パーティションと RANGE パーティションのみ利用可能 内部的には一時テーブルにデータを移動して入れ替えている 構文 ALTER TABLE table_name MERGE PARTITIONS (partition_name1, partition_name2, …) INTO partition_name 例 RANGE PARTITION 列値 100, 200 が格納されたパーティション part1v1, part1v2 をマージ postgres=> ALTER TABLE part1 MERGE PARTITIONS (part1v1, part1v2) INTO part1v3; ALTER TABLE postgres=> ¥d List of relations Schema | Name | Type | Owner --------+---------+-------------------+------- public | part1 | partitioned table | demo public | part1v3 | table | demo
nori_shinoda
gr2m
moore
jonrohan
tanoku
thoeni
colly
nonsquared
addyosmani
garrettdimon
danielanewman
soudai
wjessup
![THANK YOU Mail : [email protected] Twitter : @nori_shinoda Qiit :](https://files.speakerdeck.com/presentations/55ae0b7e378242a584a42fd6f16b6a22/slide_38.jpg){kind=link}