Commit9a39ba4

committed

Trivial patch to increase max_fsm_pages as per earlier discussion.

Philip Warner

1 parent7288439 commit9a39ba4Copy full SHA for 9a39ba4

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.164 2002/12/10 01:57:46 momjian Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.165 2002/12/27 14:06:34 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<Chapter Id="runtime">`
`@@ -1709,7 +1709,7 @@ dynamic_library_path = '/usr/local/lib/postgresql:/home/my_project/lib:$libdir'`
`1709`	`1709`	`<para>`
`1710`	`1710`	`Sets the maximum number of relations (tables) for which free`
`1711`	`1711`	`space will be tracked in the shared free-space map. The default`
`1712`		`- is100. This option can only be set at server start.`
	`1712`	`+ is1000. This option can only be set at server start.`
`1713`	`1713`	`</para>`
`1714`	`1714`	`</listitem>`
`1715`	`1715`	`</varlistentry>`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@`
`5`	`5`	`* command, configuration file, and command line options.`
`6`	`6`	`* See src/backend/utils/misc/README for more information.`
`7`	`7`	`*`
`8`		`- * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.108 2002/12/02 05:20:47 tgl Exp $`
	`8`	`+ * $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.109 2002/12/27 14:06:34 momjian Exp $`
`9`	`9`	`*`
`10`	`10`	`* Copyright 2000 by PostgreSQL Global Development Group`
`11`	`11`	`* Written by Peter Eisentraut <peter_e@gmx.net>.`
`@@ -632,7 +632,7 @@ static struct config_int`
`632`	`632`
`633`	`633`	`{`
`634`	`634`	`{"max_fsm_relations",PGC_POSTMASTER},&MaxFSMRelations,`
`635`		`-100,10,INT_MAX,NULL,NULL`
	`635`	`+1000,10,INT_MAX,NULL,NULL`
`636`	`636`	`},`
`637`	`637`	`{`
`638`	`638`	`{"max_fsm_pages",PGC_POSTMASTER},&MaxFSMPages,`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -48,7 +48,7 @@`
`48`	`48`	`#Shared Memory Size`
`49`	`49`	`#`
`50`	`50`	`#shared_buffers = 64# 2*max_connections, min 16, typically 8KB each`
`51`		`-#max_fsm_relations =100# min 10, fsm is free space map, ~40 bytes`
	`51`	`+#max_fsm_relations =1000# min 10, fsm is free space map, ~40 bytes`
`52`	`52`	`#max_fsm_pages = 10000# min 1000, fsm is free space map, ~6 bytes`
`53`	`53`	`#max_locks_per_transaction = 64# min 10`
`54`	`54`	`#wal_buffers = 8# min 4, typically 8KB each`

Comments

(0)