NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitfbb5ff3

committed

pathman: documentation and tests updated

1 parent1180c1d commitfbb5ff3Copy full SHA for fbb5ff3

File tree

5 files changed

+33

-28

lines changed

contrib/pg_pathman
- README.md
- README.rus.md
- expected
  - pg_pathman.out
- init.sql
- sql
  - pg_pathman.sql

5 files changed

+33

-28

lines changed

`‎contrib/pg_pathman/README.md`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -54,7 +54,7 @@ create_hash_partitions(`
`54`	`54`	`attribute TEXT,`
`55`	`55`	`partitions_count INTEGER)`
`56`	`56`	```
`57`		-Performs HASH partitioning for`relation` by integer key`attribute`. Creates`partitions_count` partitions and trigger on INSERT.Data doesn'tautomatically copied from parenttableto partitions. Use`partition_data()` function (see below) to migrate data.
	`57`	+Performs HASH partitioning for`relation` by integer key`attribute`. Creates`partitions_count` partitions and trigger on INSERT.All the data will beautomatically copied fromtheparent to partitions.
`58`	`58`
`59`	`59`	```
`60`	`60`	`create_range_partitions(`
`@@ -71,7 +71,7 @@ create_range_partitions(`
`71`	`71`	`interval INTERVAL,`
`72`	`72`	`premake INTEGER)`
`73`	`73`	```
`74`		-Performs RANGE partitioning for`relation` by partitioning key`attribute`.`start_value` argument specifies initial value,`interval` sets the range of values in a single partition,`premake` is the number of premade partitions.
	`74`	+Performs RANGE partitioning for`relation` by partitioning key`attribute`.`start_value` argument specifies initial value,`interval` sets the range of values in a single partition,`premake` is the number of premade partitions. All the data will be automatically copied from the parent to partitions.
`75`	`75`
`76`	`76`	```
`77`	`77`	`create_partitions_from_range(`
`@@ -88,7 +88,7 @@ create_partitions_from_range(`
`88`	`88`	`end_value ANYELEMENT,`
`89`	`89`	`interval INTERVAL)`
`90`	`90`	```
`91`		-Performs RANGE-partitioning from specified range for`relation` by partitioning key`attribute`.
	`91`	+Performs RANGE-partitioning from specified range for`relation` by partitioning key`attribute`. Data will be copied to partitions as well.
`92`	`92`
`93`	`93`	`###Utilities`
`94`	`94`	```

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

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -56,7 +56,7 @@ create_hash_partitions(`
`56`	`56`	`attribute TEXT,`
`57`	`57`	`partitions_count INTEGER)`
`58`	`58`	```
`59`		-Выполняет HASH-секционирование таблицы`relation` по целочисленному полю`attribute`. Создает`partitions_count` дочерних секций, а также триггер на вставку. Данные из родительской таблицыне копируютсяавтоматически в дочерние. Миграцию данных можно выполнить с помощью функции`partition_data()` (см. ниже), либо вручную.
	`59`	+Выполняет HASH-секционирование таблицы`relation` по целочисленному полю`attribute`. Создает`partitions_count` дочерних секций, а также триггер на вставку. Данные из родительской таблицыбудутавтоматическископированыв дочерние.
`60`	`60`
`61`	`61`	```
`62`	`62`	`create_range_partitions(`
`@@ -73,7 +73,7 @@ create_range_partitions(`
`73`	`73`	`interval INTERVAL,`
`74`	`74`	`premake INTEGER)`
`75`	`75`	```
`76`		-Выполняет RANGE-секционирование таблицы`relation` по полю`attribute`. Аргумент`start_value` задает начальное значение,`interval` -- диапазон значений внутри одной секции,`premake` -- количество заранее создаваемых секций.
	`76`	+Выполняет RANGE-секционирование таблицы`relation` по полю`attribute`. Аргумент`start_value` задает начальное значение,`interval` -- диапазон значений внутри одной секции,`premake` -- количество заранее создаваемых секций. Данные из родительской таблицы будут автоматически скопированы в дочерние.
`77`	`77`
`78`	`78`	```
`79`	`79`	`create_partitions_from_range(`
`@@ -90,7 +90,7 @@ create_partitions_from_range(`
`90`	`90`	`end_value ANYELEMENT,`
`91`	`91`	`interval INTERVAL)`
`92`	`92`	```
`93`		-Выполняет RANGE-секционирование для заданного диапазона таблицы`relation` по полю`attribute`.
	`93`	+Выполняет RANGE-секционирование для заданного диапазона таблицы`relation` по полю`attribute`. Данные также будут скопированы в дочерние секции.
`94`	`94`
`95`	`95`	`###Утилиты`
`96`	`96`	```

`‎contrib/pg_pathman/expected/pg_pathman.out`

Lines changed: 18 additions & 14 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,22 +5,39 @@ CREATE SCHEMA test;`
`5`	`5`	`CREATE TABLE test.hash_rel (`
`6`	`6`	`id SERIAL PRIMARY KEY,`
`7`	`7`	`value INTEGER);`
	`8`	`+INSERT INTO test.hash_rel VALUES (1, 1);`
	`9`	`+INSERT INTO test.hash_rel VALUES (2, 2);`
	`10`	`+INSERT INTO test.hash_rel VALUES (3, 3);`
`8`	`11`	`SELECT pathman.create_hash_partitions('test.hash_rel', 'value', 3);`
`9`	`12`	`NOTICE: function test.hash_rel_hash_insert_trigger_func() does not exist, skipping`
`10`	`13`	`NOTICE: function test.hash_rel_hash_update_trigger_func() does not exist, skipping`
`11`	`14`	`NOTICE: Copying data to partitions...`
`12`		`-NOTICE: 0 rows have been copied`
`13`	`15`	`create_hash_partitions`
`14`	`16`	`------------------------`
`15`	`17`	`3`
`16`	`18`	`(1 row)`
`17`	`19`
`18`	`20`	`SELECT COUNT(*) FROM test.hash_rel;`
`19`	`21`	`count`
	`22`	`+-------`
	`23`	`+ 3`
	`24`	`+(1 row)`
	`25`	`+`
	`26`	`+SELECT COUNT(*) FROM ONLY test.hash_rel;`
	`27`	`+ count`
`20`	`28`	`-------`
`21`	`29`	`0`
`22`	`30`	`(1 row)`
`23`	`31`
	`32`	`+INSERT INTO test.hash_rel VALUES (4, 4);`
	`33`	`+INSERT INTO test.hash_rel VALUES (5, 5);`
	`34`	`+INSERT INTO test.hash_rel VALUES (6, 6);`
	`35`	`+SELECT COUNT(*) FROM test.hash_rel;`
	`36`	`+ count`
	`37`	`+-------`
	`38`	`+ 6`
	`39`	`+(1 row)`
	`40`	`+`
`24`	`41`	`SELECT COUNT(*) FROM ONLY test.hash_rel;`
`25`	`42`	`count`
`26`	`43`	`-------`
`@@ -37,7 +54,6 @@ SELECT g, md5(g::TEXT) FROM generate_series('2015-01-01', '2015-04-30', '1 day':`
`37`	`54`	`SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '1 month'::INTERVAL, 4);`
`38`	`55`	`NOTICE: sequence "range_rel_seq" does not exist, skipping`
`39`	`56`	`NOTICE: Copying data to partitions...`
`40`		`-NOTICE: 0 rows have been copied`
`41`	`57`	`create_range_partitions`
`42`	`58`	`-------------------------`
`43`	`59`	`4`
`@@ -61,7 +77,6 @@ CREATE TABLE test.num_range_rel (`
`61`	`77`	`SELECT pathman.create_range_partitions('test.num_range_rel', 'id', 0, 1000, 4);`
`62`	`78`	`NOTICE: sequence "num_range_rel_seq" does not exist, skipping`
`63`	`79`	`NOTICE: Copying data to partitions...`
`64`		`-NOTICE: 0 rows have been copied`
`65`	`80`	`create_range_partitions`
`66`	`81`	`-------------------------`
`67`	`82`	`4`
`@@ -93,12 +108,6 @@ SELECT COUNT(*) FROM ONLY test.num_range_rel;`
`93`	`108`	`0`
`94`	`109`	`(1 row)`
`95`	`110`
`96`		`-INSERT INTO test.hash_rel VALUES (1, 1);`
`97`		`-INSERT INTO test.hash_rel VALUES (2, 2);`
`98`		`-INSERT INTO test.hash_rel VALUES (3, 3);`
`99`		`-INSERT INTO test.hash_rel VALUES (4, 4);`
`100`		`-INSERT INTO test.hash_rel VALUES (5, 5);`
`101`		`-INSERT INTO test.hash_rel VALUES (6, 6);`
`102`	`111`	`VACUUM;`
`103`	`112`	`/* update triggers test */`
`104`	`113`	`SELECT pathman.create_hash_update_trigger('test.hash_rel');`
`@@ -486,7 +495,6 @@ CREATE TABLE test.range_rel (`
`486`	`495`	`dt TIMESTAMP);`
`487`	`496`	`SELECT pathman.create_range_partitions('test.range_rel', 'dt', '2015-01-01'::DATE, '10 days'::INTERVAL, 1);`
`488`	`497`	`NOTICE: Copying data to partitions...`
`489`		`-NOTICE: 0 rows have been copied`
`490`	`498`	`create_range_partitions`
`491`	`499`	`-------------------------`
`492`	`500`	`1`
`@@ -558,7 +566,6 @@ SELECT create_hash_partitions('hash_rel', 'value', 3);`
`558`	`566`	`NOTICE: function hash_rel_hash_insert_trigger_func() does not exist, skipping`
`559`	`567`	`NOTICE: function hash_rel_hash_update_trigger_func() does not exist, skipping`
`560`	`568`	`NOTICE: Copying data to partitions...`
`561`		`-NOTICE: 0 rows have been copied`
`562`	`569`	`create_hash_partitions`
`563`	`570`	`------------------------`
`564`	`571`	`3`
`@@ -584,7 +591,6 @@ INSERT INTO range_rel (dt) SELECT g FROM generate_series('2010-01-01'::date, '20`
`584`	`591`	`SELECT create_range_partitions('range_rel', 'dt', '2010-01-01'::date, '1 month'::interval, 12);`
`585`	`592`	`NOTICE: sequence "range_rel_seq" does not exist, skipping`
`586`	`593`	`NOTICE: Copying data to partitions...`
`587`		`-NOTICE: 0 rows have been copied`
`588`	`594`	`create_range_partitions`
`589`	`595`	`-------------------------`
`590`	`596`	`12`
`@@ -669,7 +675,6 @@ SELECT drop_range_partitions('range_rel');`
`669`	`675`
`670`	`676`	`SELECT create_partitions_from_range('range_rel', 'id', 1, 1000, 100);`
`671`	`677`	`NOTICE: Copying data to partitions...`
`672`		`-NOTICE: 0 rows have been copied`
`673`	`678`	`create_partitions_from_range`
`674`	`679`	`------------------------------`
`675`	`680`	`10`
`@@ -683,7 +688,6 @@ SELECT drop_range_partitions('range_rel');`
`683`	`688`
`684`	`689`	`SELECT create_partitions_from_range('range_rel', 'dt', '2015-01-01'::date, '2015-12-01'::date, '1 month'::interval);`
`685`	`690`	`NOTICE: Copying data to partitions...`
`686`		`-NOTICE: 0 rows have been copied`
`687`	`691`	`create_partitions_from_range`
`688`	`692`	`------------------------------`
`689`	`693`	`12`

`‎contrib/pg_pathman/init.sql`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -64,7 +64,7 @@ BEGIN`
`64`	`64`	`, p_parent`
`65`	`65`	`, p_parent);`
`66`	`66`	`GET DIAGNOSTICS p_total= ROW_COUNT;`
`67`		`- RAISE NOTICE'% rows have been copied', p_total;`
	`67`	`+--RAISE NOTICE '% rows have been copied', p_total;`
`68`	`68`	`RETURN;`
`69`	`69`
`70`	`70`	`EXCEPTION WHEN others THEN`

`‎contrib/pg_pathman/sql/pg_pathman.sql`

Lines changed: 8 additions & 7 deletions

Original file line number	Diff line number	Diff line change
`@@ -7,9 +7,17 @@ CREATE SCHEMA test;`
`7`	`7`	`CREATETABLEtest.hash_rel (`
`8`	`8`	`idSERIALPRIMARY KEY,`
`9`	`9`	`valueINTEGER);`
	`10`	`+INSERT INTOtest.hash_relVALUES (1,1);`
	`11`	`+INSERT INTOtest.hash_relVALUES (2,2);`
	`12`	`+INSERT INTOtest.hash_relVALUES (3,3);`
`10`	`13`	`SELECTpathman.create_hash_partitions('test.hash_rel','value',3);`
`11`	`14`	`SELECTCOUNT(*)FROMtest.hash_rel;`
`12`	`15`	`SELECTCOUNT(*)FROM ONLYtest.hash_rel;`
	`16`	`+INSERT INTOtest.hash_relVALUES (4,4);`
	`17`	`+INSERT INTOtest.hash_relVALUES (5,5);`
	`18`	`+INSERT INTOtest.hash_relVALUES (6,6);`
	`19`	`+SELECTCOUNT(*)FROMtest.hash_rel;`
	`20`	`+SELECTCOUNT(*)FROM ONLYtest.hash_rel;`
`13`	`21`
`14`	`22`	`CREATETABLEtest.range_rel (`
`15`	`23`	`idSERIALPRIMARY KEY,`
`@@ -33,13 +41,6 @@ INSERT INTO test.num_range_rel`
`33`	`41`	`SELECTCOUNT(*)FROMtest.num_range_rel;`
`34`	`42`	`SELECTCOUNT(*)FROM ONLYtest.num_range_rel;`
`35`	`43`
`36`		`-INSERT INTOtest.hash_relVALUES (1,1);`
`37`		`-INSERT INTOtest.hash_relVALUES (2,2);`
`38`		`-INSERT INTOtest.hash_relVALUES (3,3);`
`39`		`-INSERT INTOtest.hash_relVALUES (4,4);`
`40`		`-INSERT INTOtest.hash_relVALUES (5,5);`
`41`		`-INSERT INTOtest.hash_relVALUES (6,6);`
`42`		`-`
`43`	`44`	`VACUUM;`
`44`	`45`
`45`	`46`	`/* update triggers test*/`

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!

Commitfbb5ff3

File tree

5 files changed

5 files changed

`‎contrib/pg_pathman/README.md`

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

`‎contrib/pg_pathman/expected/pg_pathman.out`

`‎contrib/pg_pathman/init.sql`

`‎contrib/pg_pathman/sql/pg_pathman.sql`

0 commit comments