Commit3e0f1a4

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 parent0083a82 commit3e0f1a4Copy full SHA for 3e0f1a4

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -4147,7 +4147,8 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="`
`4147`	`4147`	`used. When setting this parameter you should consider both`
`4148`	`4148`	`<productname>PostgreSQL</productname>'s shared buffers and the`
`4149`	`4149`	`portion of the kernel's disk cache that will be used for`
`4150`		`- <productname>PostgreSQL</productname> data files. Also, take`
	`4150`	`+ <productname>PostgreSQL</productname> data files, though some`
	`4151`	`+ data might exist in both places. Also, take`
`4151`	`4152`	`into account the expected number of concurrent queries on different`
`4152`	`4153`	`tables, since they will have to share the available`
`4153`	`4154`	`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
`@@ -2987,10 +2987,9 @@ static struct config_int ConfigureNamesInt[] =`
`2987`	`2987`
`2988`	`2988`	`{`
`2989`	`2989`	`{"effective_cache_size",PGC_USERSET,QUERY_TUNING_COST,`
`2990`		`-gettext_noop("Sets the planner's assumption about the size of the disk cache."),`
`2991`		`-gettext_noop("That is, the portion of the kernel's disk cache that "`
`2992`		`-"will be used for PostgreSQL data files. This is measured in disk "`
`2993`		`-"pages, which are normally 8 kB each."),`
	`2990`	`+gettext_noop("Sets the planner's assumption about the size of the data cache."),`
	`2991`	`+gettext_noop("That is, the size of the cache used for PostgreSQL data files. "`
	`2992`	`+"This is measured in disk pages, which are normally 8 kB each."),`
`2994`	`2993`	`GUC_UNIT_BLOCKS,`
`2995`	`2994`	`},`
`2996`	`2995`	`&effective_cache_size,`

Comments

(0)