Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

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

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit5f455c1

Browse files
committed
improve README.md
1 parentd4f0dcc commit5f455c1

File tree

1 file changed

+11
-7
lines changed

1 file changed

+11
-7
lines changed

‎README.md

Lines changed: 11 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -254,6 +254,11 @@ Set partition creation callback to be invoked for each attached or created parti
254254
}
255255
```
256256

257+
```plpgsql
258+
set_set_spawn_using_bgw(relation REGCLASS, valueBOOLEAN)
259+
```
260+
When INSERTing new data beyond the partitioning range, use SpawnPartitionsWorker to create new partitions in a separate transaction.
261+
257262
##Views and tables
258263

259264
####`pathman_config` --- main config storage
@@ -262,19 +267,18 @@ CREATE TABLE IF NOT EXISTS pathman_config (
262267
partrel REGCLASSNOT NULLPRIMARY KEY,
263268
attnameTEXTNOT NULL,
264269
parttypeINTEGERNOT NULL,
265-
range_intervalTEXT,
266-
267-
CHECK (parttypeIN (1,2))/* check for allowed part types*/ );
270+
range_intervalTEXT);
268271
```
269272
This table stores a list of partitioned tables.
270273

271274
####`pathman_config_params` --- optional parameters
272275
```plpgsql
273276
CREATETABLEIF NOT EXISTS pathman_config_params (
274-
partrel REGCLASSNOT NULLPRIMARY KEY,
275-
enable_parentBOOLEANNOT NULL DEFAULT TRUE,
276-
autoBOOLEANNOT NULL DEFAULT TRUE,
277-
init_callback REGPROCEDURENOT NULL DEFAULT0);
277+
partrel REGCLASSNOT NULLPRIMARY KEY,
278+
enable_parentBOOLEANNOT NULL DEFAULT TRUE,
279+
autoBOOLEANNOT NULL DEFAULT TRUE,
280+
init_callback REGPROCEDURENOT NULL DEFAULT0,
281+
spawn_using_bgwBOOLEANNOT NULL DEFAULT FALSE);
278282
```
279283
This table stores optional parameters which override standard behavior.
280284

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp