You signed in with another tab or window.Reload to refresh your session.You signed out in another tab or window.Reload to refresh your session.You switched accounts on another tab or window.Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: contrib/pg_pathman/README.md
+3-13Lines changed: 3 additions & 13 deletions
Original file line number
Diff line number
Diff line change
@@ -92,15 +92,11 @@ Performs RANGE-partitioning from specified range for `relation` by partitioning
92
92
93
93
###Utilities
94
94
```
95
-
partition_data(parent text)
96
-
```
97
-
Copies data from parent table to its partitions.
98
-
```
99
95
create_hash_update_trigger(parent TEXT)
100
96
```
101
97
Creates the trigger on UPDATE for HASH partitions. The UPDATE trigger isn't created by default because of overhead. It is useful in cases when key attribute could be changed.
102
98
```
103
-
create_hash_update_trigger(parent TEXT)
99
+
create_range_update_trigger(parent TEXT)
104
100
```
105
101
Same as above for RANGE sections.
106
102
@@ -139,10 +135,7 @@ If partitions are supposed to have indexes, then they should be created for pare
This will create new partitions but data will still be in the parent table. To move data to the corresponding partitions use partition_data() function:
143
-
```
144
-
SELECT partition_data('hash_rel');
145
-
```
138
+
This will create new partitions and move the data from parent to partitions.
146
139
Here is an example of the query with filtering by partitioning key and its plan:
147
140
```
148
141
SELECT * FROM hash_rel WHERE value = 1234;
@@ -176,10 +169,7 @@ Run create_range_partitions() function to create partitions so that each partiti
Copy file name to clipboardExpand all lines: contrib/pg_pathman/README.rus.md
+1-14Lines changed: 1 addition & 14 deletions
Original file line number
Diff line number
Diff line change
@@ -94,15 +94,11 @@ create_partitions_from_range(
94
94
95
95
###Утилиты
96
96
```
97
-
partition_data(parent text)
98
-
```
99
-
Копирует данные из родительской таблицы`parent` в дочерние секции.
100
-
```
101
97
create_hash_update_trigger(parent TEXT)
102
98
```
103
99
Создает триггер на UPDATE для HASH секций. По-умолчанию триггер на обновление данных не создается, т.к. это создает дополнительные накладные расходы. Триггер полезен только в том случае, когда меняется значение ключевого аттрибута.
104
100
```
105
-
create_hash_update_trigger(parent TEXT)
101
+
create_range_update_trigger(parent TEXT)
106
102
```
107
103
Аналогично предыдущей, но для RANGE секций.
108
104
@@ -141,10 +137,6 @@ INSERT INTO hash_rel (value) SELECT g FROM generate_series(1, 10000) as g;