NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit1e0e9b5

committed

pathman: doc updated

1 parentfbb5ff3 commit1e0e9b5Copy full SHA for 1e0e9b5

File tree

2 files changed

-27

lines changed

contrib/pg_pathman
- README.md
- README.rus.md

2 files changed

-27

lines changed

`‎contrib/pg_pathman/README.md`

Lines 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`
`139`	`135`	```
`140`	`136`	`SELECT create_hash_partitions('hash_rel', 'value', 100);`
`141`	`137`	```
`142`		`-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`
`176`	`169`	```
`177`	`170`	`SELECT create_range_partitions('range_rel', 'dt', '2010-01-01'::date, '1 month'::interval, 60);`
`178`	`171`	```
`179`		`-It will create 60 partitions. Now let's move data from the parent to partitions.`
`180`		-```
`181`		`-SELECT partition_data('range_rel');`
`182`		-```
	`172`	`+It will create 60 partitions and move the data from parent to partitions.`
`183`	`173`	`To merge to adjacent partitions run merge_range_partitions() function:`
`184`	`174`	```
`185`	`175`	`SELECT merge_range_partitions('range_rel_1', 'range_rel_2');`

`‎contrib/pg_pathman/README.rus.md`

Lines 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;`
`141`	`137`	```
`142`	`138`	`SELECT create_hash_partitions('hash_rel', 'value', 100);`
`143`	`139`	```
`144`		`-Перенесем данные из родительской таблицы в дочерние секции.`
`145`		-```
`146`		`-SELECT partition_data('hash_rel');`
`147`		-```
`148`	`140`	`Пример построения плана для запроса с фильтрацией по ключевому полю:`
`149`	`141`	```
`150`	`142`	`SELECT * FROM hash_rel WHERE value = 1234;`
`@@ -179,11 +171,6 @@ INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '20`
`179`	`171`	```
`180`	`172`	`SELECT create_range_partitions('range_rel', 'dt', '2010-01-01'::date, '1 month'::interval, 60);`
`181`	`173`	```
`182`		`-`
`183`		`-Перенесем данные из родительской таблицы в дочерние секции.`
`184`		-```
`185`		`-SELECT partition_data('range_rel');`
`186`		-```
`187`	`174`	`Объединим секции первые две секции:`
`188`	`175`	```
`189`	`176`	`SELECT merge_range_partitions('range_rel_1', 'range_rel_2');`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit1e0e9b5

File tree

2 files changed

2 files changed

`‎contrib/pg_pathman/README.md`

`‎contrib/pg_pathman/README.rus.md`

0 commit comments