Commit2352441

committed

GUC: adjust effective_cache_size docs and SQL description

Clarify that effective_cache_size is both kernel buffers and sharedbuffers.Reported-by: nat@makarevitch.orgDiscussion:https://postgr.es/m/153685164808.22334.15432535018443165207@wrigleys.postgresql.orgBackpatch-through: 9.3

1 parent708b96d commit2352441Copy full SHA for 2352441

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4143,7 +4143,8 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="`
`4143`	`4143`	`used. When setting this parameter you should consider both`
`4144`	`4144`	`<productname>PostgreSQL</productname>'s shared buffers and the`
`4145`	`4145`	`portion of the kernel's disk cache that will be used for`
`4146`		`- <productname>PostgreSQL</productname> data files. Also, take`
	`4146`	`+ <productname>PostgreSQL</productname> data files, though some`
	`4147`	`+ data might exist in both places. Also, take`
`4147`	`4148`	`into account the expected number of concurrent queries on different`
`4148`	`4149`	`tables, since they will have to share the available`
`4149`	`4150`	`space. This parameter has no effect on the size of shared`

Lines changed: 3 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -2979,10 +2979,9 @@ static struct config_int ConfigureNamesInt[] =`
`2979`	`2979`
`2980`	`2980`	`{`
`2981`	`2981`	`{"effective_cache_size",PGC_USERSET,QUERY_TUNING_COST,`
`2982`		`-gettext_noop("Sets the planner's assumption about the size of the disk cache."),`
`2983`		`-gettext_noop("That is, the portion of the kernel's disk cache that "`
`2984`		`-"will be used for PostgreSQL data files. This is measured in disk "`
`2985`		`-"pages, which are normally 8 kB each."),`
	`2982`	`+gettext_noop("Sets the planner's assumption about the size of the data cache."),`
	`2983`	`+gettext_noop("That is, the size of the cache used for PostgreSQL data files. "`
	`2984`	`+"This is measured in disk pages, which are normally 8 kB each."),`
`2986`	`2985`	`GUC_UNIT_BLOCKS,`
`2987`	`2986`	`},`
`2988`	`2987`	`&effective_cache_size,`

Comments

(0)