Commit5463deb

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 parent919cffd commit5463debCopy full SHA for 5463deb

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3962,7 +3962,8 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="`
`3962`	`3962`	`used. When setting this parameter you should consider both`
`3963`	`3963`	`<productname>PostgreSQL</productname>'s shared buffers and the`
`3964`	`3964`	`portion of the kernel's disk cache that will be used for`
`3965`		`- <productname>PostgreSQL</productname> data files. Also, take`
	`3965`	`+ <productname>PostgreSQL</productname> data files, though some`
	`3966`	`+ data might exist in both places. Also, take`
`3966`	`3967`	`into account the expected number of concurrent queries on different`
`3967`	`3968`	`tables, since they will have to share the available`
`3968`	`3969`	`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
`@@ -2803,10 +2803,9 @@ static struct config_int ConfigureNamesInt[] =`
`2803`	`2803`
`2804`	`2804`	`{`
`2805`	`2805`	`{"effective_cache_size",PGC_USERSET,QUERY_TUNING_COST,`
`2806`		`-gettext_noop("Sets the planner's assumption about the size of the disk cache."),`
`2807`		`-gettext_noop("That is, the portion of the kernel's disk cache that "`
`2808`		`-"will be used for PostgreSQL data files. This is measured in disk "`
`2809`		`-"pages, which are normally 8 kB each."),`
	`2806`	`+gettext_noop("Sets the planner's assumption about the size of the data cache."),`
	`2807`	`+gettext_noop("That is, the size of the cache used for PostgreSQL data files. "`
	`2808`	`+"This is measured in disk pages, which are normally 8 kB each."),`
`2810`	`2809`	`GUC_UNIT_BLOCKS,`
`2811`	`2810`	`},`
`2812`	`2811`	`&effective_cache_size,`

Comments

(0)