Postgresql 10 range partition

Поиск
Список
Период
Сортировка
Искать
От
Garry Chen
Тема
Postgresql 10 range partition
Дата
Msg-id
A004F027-702E-42F9-A725-D4044CD8DA5F@cornell.edu
Список
Дерево обсуждения
Postgresql 10 range partition Garry Chen <gc92@cornell.edu>
Re: Postgresql 10 range partition "David G. Johnston" <david.g.johnston@gmail.com>

HI All,

                I would like to create a range partition table but my question is when create the partitions can I use for values less then?  If LESS THEN is not passable what is my options?  Here is what I try to do.

 

CREATE TABLE measurement (

    city_id                     int not null,

    MONTH_SID         integer not null,

    peaktemp              int,

    unitsales                 int

) PARTITION BY RANGE (MONTH_SID);

CREATE TABLE measurement_y2010 PARTITION OF measurement

    FOR VALUES LESS THEN (201007)

NOTE: Any month_SID values less than 2010 July

CREATE TABLE measurement_y2011 PARTITION OF measurement

    FOR VALUES LESS THEN (201107)

NOTE: Any month_SID values between 2010 July  and 2011 June

….

Skip here

….

CREATE TABLE measurement_y2017 PARTITION OF measurement

    FOR VALUES LESS THEN (201707)

NOTE: Any month_SID values between 2016 July  and 2017 June

CREATE TABLE measurement_y2018 PARTITION OF measurement

    FOR VALUES LESS THEN (201807)

NOTE: Any month_SID values between 2017 July  and 2018 June

 

Thank you very much for your input,

Garry

 

В списке pgsql-novice по дате отправления
От: john snow
Дата:
От: David G. Johnston
Дата:
FAQ