pgpool2.git / summary / log / commit / refs
commit d6b3e4da9bef3710752b8f3f8811101826b2f52d
Author: Tatsuo Ishii <ishii at sraoss.co.jp>
Date: Tue Aug 24 05:37:12 2010 +0000
Add metiontion about using row lock, rather than table lock when
inser_lock is enabled.
doc/pgpool-en.html | 12 +++++++++---
doc/pgpool-ja.html | 17 ++++++++++-------
2 files changed, 19 insertions(+), 10 deletions(-)
diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index 22eb24029..4b4144364 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -7,7 +7,7 @@
</head>
<!-- hhmts start -->
-Last modified: Wed Aug 18 08:57:54 JST 2010
+Last modified: Tue Aug 24 14:35:48 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -1028,8 +1028,14 @@ be lost). To achieve this, however, the following change must be made:
....).
As of pgpool-II 2.2, it automatically detects if the table has a
- SERIAL columns or not, so only tables having SERIAL columns are locked.
-
+ SERIAL columns or not, so only tables having SERIAL columns are
+ locked.
+ <p>
+ pgpool-II 3.0 or later uses row lock against the sequence
+ relation, rather than table lock. This will minimize lock
+ conflict with VACUUM(including autovacuum).
+ </p>
+ <p>
Also you might want to make a fine control:
</p>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index 6408411bd..7da0e7e47 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
<body>
<!-- hhmts start -->
-Last modified: Thu Aug 19 18:16:20 JST 2010
+Last modified: Tue Aug 24 14:36:00 JST 2010
<!-- hhmts end -->
<body bgcolor="#ffffff">
@@ -1032,19 +1032,22 @@ replicate_select$B!"(Bload_balance_mode$B!"(BSELECT$BLd9g$o$;$,L@<(E*$J%H%i
$B%s%6%/%7%g%s$N3+;O!"%F!<%V%k%m%C%/!"%H%i%s%6%/%7%g%s$N=*N;$r9T$C$F(B
$B$/$l$k$N$G!"$3$&$7$?<j4V$r>J$/$3$H$,$G$-$^$9!J$9$G$K%H%i%s%6%/%7%g(B
$B%s$,3+;O$5$l$F$$$k>l9g$O(BLOCK TABLE...$B$@$1$,<B9T$5$l$^$9!K!#(B
+</p>
+<p>
+$B$J$*!"(Bpgpool-II 3.0$B0J9_$G$O!"BP1~$9$k%7!<%1%s%9%F!<%V%k$KBP$7$F9T%m%C%/$r9T$J$&$3$H$K$h$C$FGSB>@)8f$r9T$J$$$^$9!#$=$l0JA0$N%P!<%8%g%s$HHf$Y$k$H!"(BVACUUM(autovacuum$B$r4^$`(B)$B$H$N%m%C%/6%9g$,$J$/$J$k%a%j%C%H$,$"$j$^$9!#(B
+</p>
+<p>
$B%F!<%V%k$G(BSERIAL$B7?$,;H$o$l$F$$$J$$>l9g$K$O!"%F!<%V%k$N%m%C%/$O9T$J$o$l$^$;$s!#(B
$B$J$*!"$"$^$jI,MW$J$$$+$bCN$l$^$;$s$,!"%3%a%s%H$rMxMQ$7$F!"$3$N5sF0$r(B
$B:Y$+$/@)8f$9$k$3$H$b$G$-$^$9!#(B
</p>
<ol>
-<li>insert_lock$B$r(Btrue$B$K$7$F!"(BINSERT$BJ8$N@hF,$K(B/*NO INSERT LOCK*/$B%3%a(B
- $B%s%H$rDI2C$9$k!#$3$N%3%a%s%H$,$"$k$H!"%F!<%V%k%m%C%/$O9T$o$l$^$;(B
- $B$s!#(B
+<li>insert_lock$B$r(Btrue$B$K$7$F!"(BINSERT$BJ8$N@hF,$K(B/*NO INSERT LOCK*/$B%3%a%s%H$rDI2C$9$k!#(B
+$B$3$N%3%a%s%H$,$"$k$H!"%F!<%V%k%m%C%/$O9T$o$l$^$;$s(B(pgpool-II 3.0$B0J9_$G$bF1MM(B)$B!#(B
-<li>insert_lock$B$r(Bfalse$B$K$7$F!"(BINSERT$BJ8$N@hF,$K(B/*INSERT LOCK*/$B%3%a%s(B
- $B%H$rDI2C$9$k!#$3$N%3%a%s%H$,$"$k$H!"$3$N(BINSERT$BJ8$KBP$7$F$N$_%F!<(B
- $B%V%k%m%C%/$,9T$o$l$^$9!#(B
+<li>insert_lock$B$r(Bfalse$B$K$7$F!"(BINSERT$BJ8$N@hF,$K(B/*INSERT LOCK*/$B%3%a%s%H$rDI2C$9$k!#(B
+$B$3$N%3%a%s%H$,$"$k$H!"$3$N(BINSERT$BJ8$KBP$7$F$N$_%F!<%V%k%m%C%/$,9T$o$l$^$9(B(pgpool-II 3.0$B0J9_$G$bF1MM(B)$B!#(B
</ol>
<p>
[parent: 6baf12010f59]