Commitf7bda63

committed

Improve defaults shown in postgresql.conf.sample and pg_settings

Previously, these showed unlikely default values. The new default value128MB (since PG 10) is not always accurate since initdb tries severalincreasing values, but it likely to be accurate.Reported-by: Zhangjie <zhangjie2@fujitsu.com>Discussion:https://postgr.es/m/TYWPR01MB7678772FD8640C404F1DC882F9079@TYWPR01MB7678.jpnprd01.prod.outlook.comAuthor: ZhangjieBackpatch-through: master

1 parenta3fcbcd commitf7bda63Copy full SHA for f7bda63

File tree

-3

lines changed

-3

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2333,7 +2333,7 @@ static struct config_int ConfigureNamesInt[] =`
`2333`	`2333`	`GUC_UNIT_BLOCKS`
`2334`	`2334`	`},`
`2335`	`2335`	`&NBuffers,`
`2336`		`-1024,16,INT_MAX /2,`
	`2336`	`+16384,16,INT_MAX /2,`
`2337`	`2337`	`NULL,NULL,NULL`
`2338`	`2338`	`},`
`2339`	`2339`

Lines changed: 1 addition & 1 deletion

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1071,7 +1071,7 @@ setup_config(void)`
`1071`	`1071`	`else`
`1072`	`1072`	`snprintf(repltok,sizeof(repltok),"shared_buffers = %dkB",`
`1073`	`1073`	`n_buffers* (BLCKSZ /1024));`
`1074`		`-conflines=replace_token(conflines,"#shared_buffers =32MB",repltok);`
	`1074`	`+conflines=replace_token(conflines,"#shared_buffers =128MB",repltok);`
`1075`	`1075`
`1076`	`1076`	`#ifdefHAVE_UNIX_SOCKETS`
`1077`	`1077`	`snprintf(repltok,sizeof(repltok),"#unix_socket_directories = '%s'",`

Comments

(0)