Commit7fc0c4c

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 parentf499dab commit7fc0c4cCopy full SHA for 7fc0c4c

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2902,7 +2902,8 @@ include 'filename'`
`2902`	`2902`	`used. When setting this parameter you should consider both`
`2903`	`2903`	`<productname>PostgreSQL</productname>'s shared buffers and the`
`2904`	`2904`	`portion of the kernel's disk cache that will be used for`
`2905`		`- <productname>PostgreSQL</productname> data files. Also, take`
	`2905`	`+ <productname>PostgreSQL</productname> data files, though some`
	`2906`	`+ data might exist in both places. Also, take`
`2906`	`2907`	`into account the expected number of concurrent queries on different`
`2907`	`2908`	`tables, since they will have to share the available`
`2908`	`2909`	`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
`@@ -2406,10 +2406,9 @@ static struct config_int ConfigureNamesInt[] =`
`2406`	`2406`
`2407`	`2407`	`{`
`2408`	`2408`	`{"effective_cache_size",PGC_USERSET,QUERY_TUNING_COST,`
`2409`		`-gettext_noop("Sets the planner's assumption about the size of the disk cache."),`
`2410`		`-gettext_noop("That is, the portion of the kernel's disk cache that "`
`2411`		`-"will be used for PostgreSQL data files. This is measured in disk "`
`2412`		`-"pages, which are normally 8 kB each."),`
	`2409`	`+gettext_noop("Sets the planner's assumption about the size of the data cache."),`
	`2410`	`+gettext_noop("That is, the size of the cache used for PostgreSQL data files. "`
	`2411`	`+"This is measured in disk pages, which are normally 8 kB each."),`
`2413`	`2412`	`GUC_UNIT_BLOCKS,`
`2414`	`2413`	`},`
`2415`	`2414`	`&effective_cache_size,`

Comments

(0)