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: README.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -123,7 +123,7 @@ CREATE TABLE hash_rel (
123
123
value INTEGER);
124
124
INSERT INTO hash_rel (value) SELECT g FROM generate_series(1, 10000) as g;
125
125
```
126
-
Then run create_hash_partitions() function with appropriate arguments:
126
+
If partitions are supposed to have indexes, then they should be created for parent table before partitioning. In this case pg_pathman will automaticaly create indexes for partitions.Then run create_hash_partitions() function with appropriate arguments:
Copy file name to clipboardExpand all lines: README.rus.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -124,7 +124,7 @@ CREATE TABLE hash_rel (
124
124
value INTEGER);
125
125
INSERT INTO hash_rel (value) SELECT g FROM generate_series(1, 10000) as g;
126
126
```
127
-
Разобьем таблицу`hash_rel` на 100 секций по полю`value`:
127
+
Если дочерние секции подразумевают наличие индексов, то стоит их создать в родительской таблице до разбиения. Тогда при разбиении pg_pathman автоматически создаст соответствующие индексы в дочерних.таблицах.Разобьем таблицу`hash_rel` на 100 секций по полю`value`: