Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitdfdbf68

Browse files
committed
max_locks_per_transaction seems to be a more consistent name than
max_locks_per_xact.
1 parentdddd95a commitdfdbf68

File tree

3 files changed

+6
-6
lines changed

3 files changed

+6
-6
lines changed

‎doc/src/sgml/runtime.sgml

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.77 2001/09/09 23:52:12 petere Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.78 2001/09/12 14:06:37 petere Exp $
33
-->
44

55
<Chapter Id="runtime">
@@ -1187,11 +1187,11 @@ dynamic_library_path = '/usr/local/lib:/home/my_project/lib:$libdir:$libdir/cont
11871187
</varlistentry>
11881188

11891189
<varlistentry>
1190-
<term><varname>MAX_LOCKS_PER_XACT</varname> (<type>integer</type>)</term>
1190+
<term><varname>MAX_LOCKS_PER_TRANSACTION</varname> (<type>integer</type>)</term>
11911191
<listitem>
11921192
<para>
11931193
The shared lock table is sized on the assumption that at most
1194-
<varname>max_locks_per_xact</> * <varname>max_connections</varname> distinct objects will need
1194+
<varname>max_locks_per_transaction</> * <varname>max_connections</varname> distinct objects will need
11951195
to be locked at any one time. The default, 64, has historically
11961196
proven sufficient, but you might need to raise this value if you
11971197
have clients that touch many different tables in a single transaction.

‎src/backend/utils/misc/guc.c

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@
44
* Support for grand unified configuration scheme, including SET
55
* command, configuration file, and command line options.
66
*
7-
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.47 2001/09/07 00:27:29 tgl Exp $
7+
* $Header: /cvsroot/pgsql/src/backend/utils/misc/guc.c,v 1.48 2001/09/12 14:06:37 petere Exp $
88
*
99
* Copyright 2000 by PostgreSQL Global Development Group
1010
* Written by Peter Eisentraut <peter_e@gmx.net>.
@@ -317,7 +317,7 @@ static struct config_int
317317
{"max_fsm_pages",PGC_POSTMASTER,&MaxFSMPages,
318318
10000,1000,INT_MAX,NULL,NULL},
319319

320-
{"max_locks_per_xact",PGC_POSTMASTER,&max_locks_per_xact,
320+
{"max_locks_per_transaction",PGC_POSTMASTER,&max_locks_per_xact,
321321
64,10,INT_MAX,NULL,NULL},
322322

323323
{"checkpoint_segments",PGC_SIGHUP,&CheckPointSegments,

‎src/backend/utils/misc/postgresql.conf.sample

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -47,7 +47,7 @@
4747
#shared_buffers = 64 # 2*max_connections, min 16
4848
#max_fsm_relations = 100 # min 10
4949
#max_fsm_pages = 10000 # min 1000
50-
#max_locks_per_xact = 64 # min 10
50+
#max_locks_per_transaction = 64 # min 10
5151
#wal_buffers = 8 # min 4
5252

5353
#

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp