Commit2a279b6

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 parent4f67ff1 commit2a279b6Copy full SHA for 2a279b6

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3760,7 +3760,8 @@ include_dir 'conf.d'`
`3760`	`3760`	`used. When setting this parameter you should consider both`
`3761`	`3761`	`<productname>PostgreSQL</productname>'s shared buffers and the`
`3762`	`3762`	`portion of the kernel's disk cache that will be used for`
`3763`		`- <productname>PostgreSQL</productname> data files. Also, take`
	`3763`	`+ <productname>PostgreSQL</productname> data files, though some`
	`3764`	`+ data might exist in both places. Also, take`
`3764`	`3765`	`into account the expected number of concurrent queries on different`
`3765`	`3766`	`tables, since they will have to share the available`
`3766`	`3767`	`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
`@@ -2738,10 +2738,9 @@ static struct config_int ConfigureNamesInt[] =`
`2738`	`2738`
`2739`	`2739`	`{`
`2740`	`2740`	`{"effective_cache_size",PGC_USERSET,QUERY_TUNING_COST,`
`2741`		`-gettext_noop("Sets the planner's assumption about the size of the disk cache."),`
`2742`		`-gettext_noop("That is, the portion of the kernel's disk cache that "`
`2743`		`-"will be used for PostgreSQL data files. This is measured in disk "`
`2744`		`-"pages, which are normally 8 kB each."),`
	`2741`	`+gettext_noop("Sets the planner's assumption about the size of the data cache."),`
	`2742`	`+gettext_noop("That is, the size of the cache used for PostgreSQL data files. "`
	`2743`	`+"This is measured in disk pages, which are normally 8 kB each."),`
`2745`	`2744`	`GUC_UNIT_BLOCKS,`
`2746`	`2745`	`},`
`2747`	`2746`	`&effective_cache_size,`

Comments

(0)