pgpool2.git / summary / log / commit / refs
commit 4f52b4d07ed2008f683203876c210e1b58864aae
Author: Tatsuo Ishii <ishii at sraoss.co.jp>
Date: Thu Aug 12 00:25:27 2010 +0000
Enhancing docs.
doc/pgpool-en.html | 40 ++++++++++++++++++++++++++++++++--------
doc/pgpool-ja.html | 4 +++-
2 files changed, 35 insertions(+), 9 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 2953bd3ff..14802d5cd 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -7,7 +7,7 @@
</head>
<!-- hhmts start -->
-Last modified: Wed Aug 11 17:11:10 JST 2010
+Last modified: Thu Aug 12 08:36:10 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -397,12 +397,34 @@ comment and will be ignored.</p>
<dt>num_init_children</dt>
<dd>
<p>The number of preforked pgpool-II server processes. Default
- is 32. Please note that cancelling a query creates another
- connection to the backend; thus, a query cannot be cancelled if
- the connections are full. If you want to ensure that queries can
- be cancelled, set this value to twice the expected
- connections. This parameter can only be set at server start.</p>
- </dd>
+ is 32. num_init_children limits the concurrent connections to
+ pgpool-II from clients. If more than num_init_children clients
+ try to connect to pgpool-II, they are blocked (not trigger errors)
+ until connections to any of pgpool-II processes are closed.</p>
+ <p>Some hints in addition to above:</p>
+ <p>
+ <ul>
+ <li>Cancelling a query creates another
+ connection to the backend; thus, a query cannot be cancelled if
+ the connections are full. If you want to ensure that queries can
+ be cancelled, set this value to twice the expected
+ connections.</li>
+
+ <li>PostgreSQL allow concurrent connections for non super users up
+ to max_connections - superuser_reserved_connections.</li>
+ </ul>
+ </p>
+ <p>In summary, max_pool, num_init_childredn, max_connections,
+ superuser_reserved_connections must satisfy following formula:
+ </p>
+ <p>
+ <pre>
+max_pool*num_init_children <= (max_connections - superuser_reserved_connections) (no query canceling needed)
+max_pool*num_init_children*2 <= (max_connections - superuser_reserved_connections) (query canceling needed)
+ </pre>
+ <p>
+ This parameter can only be set at server start.</p>
+ </dd>
<dt>child_life_time</dt>
<dd>
@@ -1222,7 +1244,9 @@ alive.</p>
<p>This mode is for using pgpool-II with another master/slave
replication software (like Slony-I and Streaming replication), so it really does the actual data
-replication. DB nodes' information must be set as the replication mode.
+replication. DB nodes' information(backend_hostname, backend_port,
+backend_weight, backend_data_directory, only if you need to do the
+online recovery) must be set as the replication mode.
In addtion to that, set
<code>master_slave_mode</code> and <code>load_balance_mode</code> to
true. pgpool-II will send queries that need to be replicated to the
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index dde57cb28..403753271 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
<body>
<!-- hhmts start -->
-Last modified: Wed Aug 11 16:02:27 JST 2010
+Last modified: Thu Aug 12 08:25:49 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -409,6 +409,8 @@ pcp$B$,(Bpgppool$B$H@\B3$9$k:]$N%?%$%`%"%&%HCM!#(B0$B$K$9$k$H%?%$%`%"%&%H$7
<dd>
<p>
prefork$B$9$k(Bpgpool-II$B$N%5!<%P%W%m%;%9$N?t$G$9!#%G%U%)%k%HCM$O(B32$B$K$J$C$F$$$^$9!#(B
+$B$3$l$,!"(Bpgpool-II$B$KBP$7$F%/%i%$%"%s%H$,F1;~$K@\B3$G$-$k>e8B$N?t$K$J$j$^$9!#(B
+$B$3$l$rD6$($?>l9g$O!"$=$N%/%i%$%"%s%H$O!"(Bpgpool-II$B$N$I$l$+$i$N%W%m%;%9$X$N%U%m%s%H%(%s%I$N@\B3$,=*N;$9$k$^$GBT$?$5$l$^$9(B(PostgreSQL$B$H0c$C$F%(%i!<$K$J$j$^$;$s(B)$B!#(B
$B4pK\E*$K8e=R$N(Bmax_pool*num_init_children$BJ,$@$1(BPostgreSQL$B$X$N%3%M%/%7%g%s$,D%$i$l$^$9$,!"B>$K0J2<$N9MN8$,I,MW$G$9!#(B
<ul>
<li>$BLd$$9g$o$;$N%-%c%s%;%k$r9T$&$HDL>o$N%3%M%/%7%g%s$H$OJL$K?7$?$J%3%M%/%7%g%s$,D%$i$l$^$9!#(B
[parent: 753fc4bcd982]