pgpool2.git / summary / log / commit / refs

commit    7b9b2928592abf31db7f73582d8b1cbeee1dfe2b
Author:   Yoshiharu Mori <y-mori at sraoss.co.jp>
Date:     Fri Nov 16 05:29:15 2007 +0000

    ADD: documents (Setting method of Query cache)


 doc/pgpool-en.html | 24 ++++++++++++++++++++++++
 doc/pgpool-ja.html | 26 ++++++++++++++++++++++++++
 2 files changed, 50 insertions(+)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index bda51f1f0..870ca4b93 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -1062,6 +1062,30 @@ ELSE 2
   service-configuration file is installed as "share/pgpool.pam" under
   the install directory.
 </p>
+
+<h2>Setting method of Query cache</h2>
+<p>The Query cache can be used in all modes in pgpool-II. The setting of pgpool.conf is set as follows.</p>
+<pre>
+enable_query_cache = true
+</pre>
+
+<p>
+Moreover, please make the following tables in the System DB. 
+</p>
+<pre>
+CREATE TABLE pgpool_catalog.query_cache (
+  hash TEXT,
+  query TEXT,
+  value bytea,
+  dbname TEXT,
+  create_time TIMESTAMP WITH TIME ZONE,
+  PRIMARY KEY(hash, dbname)
+);
+</pre>
+<p>
+However, please rewrite it suitably when you use a different schema because the schema name is "pgpool_catalog" in this example. 
+</p>
+
 <h1>Starting/Stopping pgpool-II<a name="start"></a></h1>
 
 <p>All the backends and the System DB (if necessary) must be started
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index eb516d3bc..622930065 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -1227,6 +1227,32 @@ CREATE OR REPLACE FUNCTION pgpool_catalog.dist_def_accounts (val ANYELEMENT) RET
    $B$@$5$$!#(B
 </p>
 
+<h2>$B%/%(%j%-%c%C%7%e$N@_DjJ}K!(B</h2>
+
+<p>
+	pgpool-II$B$G$O!"$9$Y$F$N%b!<%I$G%/%(%j%-%c%C%7%e$rMxMQ$9$k$3$H$,$G$-$^$9!#(B
+  $BMxMQ$9$k>l9g$K$O!"(Bpgpool.conf$B$N@_Dj$r0J2<$N$h$&$K@_Dj$7$^$9!#(B
+<pre>
+enable_query_cache = true
+</pre>
+<p>
+$B$^$?!"%7%9%F%`(BDB$B$K0J2<$N%F!<%V%k$r:n@.$7$F$/$@$5$$!#(B
+</p>
+<pre>
+CREATE TABLE pgpool_catalog.query_cache (
+  hash TEXT,
+  query TEXT,
+  value bytea,
+  dbname TEXT,
+  create_time TIMESTAMP WITH TIME ZONE,
+  PRIMARY KEY(hash, dbname)
+);
+</pre>
+<p>
+$B$?$@$7!$$3$NNc$G$O%9%-!<%^L>$,(B"pgpool_catalog"$B$H$J$C$F$$$k$N$G!$0c$&%9%-!<%^$r;H$&>l9g$OE,Ev$K=q$-49$($F$/$@$5$$!%(B
+</p>
+
+
 <h1>pgpool-II$B$N5/F0$HDd;_(B<a name="start"></a></h1>
 <p>
 $B0J>e$G@_Dj$,=*$o$C$?$N$G!$3F(BDB$B%N!<%I$r5/F0$7!$I,MW$J$i$P%7%9%F%`(BDB$B$b5/F0(B


[parent: 0298f7b83c7b]