File tree Expand file tree Collapse file tree 2 files changed +3
-3
lines changed Expand file tree Collapse file tree 2 files changed +3
-3
lines changed Original file line number Diff line number Diff line change @@ -135,7 +135,7 @@ Consider an example of RANGE partitioning. Create a table with numerical or date
135
135
CREATE TABLE range_rel (
136
136
id SERIAL PRIMARY KEY,
137
137
dt TIMESTAMP);
138
- INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2015 -12-31'::date, '1 day') as g;
138
+ INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2014 -12-31'::date, '1 day') as g;
139
139
```
140
140
Run create_range_partitions() function to create partitions so that each partition would contain data for one month:
141
141
```
@@ -153,7 +153,7 @@ To split partition use split_range_partition() function:
153
153
```
154
154
SELECT split_range_partition('range_rel_1', '2010-02-15'::date);
155
155
```
156
- Now let's create new partitions . You can use append_partition() or prepend_partition() functions:
156
+ Now let's create new partition . You can use append_partition() or prepend_partition() functions:
157
157
```
158
158
SELECT append_partition('range_rel');
159
159
SELECT prepend_partition('range_rel');
Original file line number Diff line number Diff line change @@ -137,7 +137,7 @@ SELECT partition_data('hash_rel');
137
137
CREATE TABLE range_rel (
138
138
id SERIAL PRIMARY KEY,
139
139
dt TIMESTAMP);
140
- INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2015 -12-31'::date, '1 day') as g;
140
+ INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '2014 -12-31'::date, '1 day') as g;
141
141
```
142
142
Разобьем таблицу на 60 секций так, чтобы каждая секция содержала данные за один месяц:
143
143
```
You can’t perform that action at this time.
0 commit comments