diff options
| author | Tatsuo Ishii | 2024-10-26 03:29:09 +0000 |
|---|---|---|
| committer | Tatsuo Ishii | 2024-10-26 03:29:09 +0000 |
| commit | 6b715386cd88ad02a25c893b1bd73e89b7fa849f (patch) | |
| tree | a62da9d21c8239f86576ef685e2c77b5a633825d | |
| parent | 4871a30d77ae1436eb8ec816fe4f0a21091b0b84 (diff) | |
Doc: enhance query cache documents.
Mention that we can use PGPOOL SET CACHE DELETE or
pcp_invalidate_query_cache command to delete query cache.
| -rw-r--r-- | doc.ja/src/sgml/memcache.sgml | 6 | ||||
| -rw-r--r-- | doc/src/sgml/memcache.sgml | 5 |
2 files changed, 9 insertions, 2 deletions
diff --git a/doc.ja/src/sgml/memcache.sgml b/doc.ja/src/sgml/memcache.sgml index 2145e88c5..d7c9a493e 100644 --- a/doc.ja/src/sgml/memcache.sgml +++ b/doc.ja/src/sgml/memcache.sgml @@ -39,7 +39,10 @@ /*NO QUERY CACHE*/SELECT now(); </programlisting> Because it just prevents to create a cache entry for the query, and - does not affect the query using the FORCE QUERY CACHE comment. + does not affect the query using the FORCE QUERY CACHE comment. You + can delete such a query cache by + using <xref linkend="SQL-PGPOOL-SET-CACHE"> command, + or <xref linkend="PCP-INVALIDATE-QUERY-CACHE"> command. </programlisting> Because it just prevents to create a cache entry for the query, and does not affect the query using the FORCE QUERY CACHE comment. @@ -60,6 +63,7 @@ /*NO QUERY CACHE*/SELECT now(); </programlisting> なぜなら、これはこのクエリのキャッシュエントリが作成されないようにするだけで、FORCE QUERY CACHEコメントを使ったクエリには影響を与えないからです。 + このようなクエリキャッシュは、<xref linkend="SQL-PGPOOL-SET-CACHE">コマンドか、<xref linkend="PCP-INVALIDATE-QUERY-CACHE">コマンドで削除できます。 </para> <para> <!-- diff --git a/doc/src/sgml/memcache.sgml b/doc/src/sgml/memcache.sgml index e87573c51..6cd920531 100644 --- a/doc/src/sgml/memcache.sgml +++ b/doc/src/sgml/memcache.sgml @@ -39,7 +39,10 @@ /*NO QUERY CACHE*/SELECT now(); </programlisting> Because it just prevents to create a cache entry for the query, and - does not affect the query using the FORCE QUERY CACHE comment. + does not affect the query using the FORCE QUERY CACHE comment. You + can delete such a query cache by + using <xref linkend="SQL-PGPOOL-SET-CACHE"> command, + or <xref linkend="PCP-INVALIDATE-QUERY-CACHE"> command. </para> <para> Note that for following query: |