[pgpool-general: 8534] Re: Cache configuration
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Jan 3 18:19:30 JST 2023
> Thank you for the clarification.
No problem.
> One more question, is it possible that a query result will store in more
> than one entry?
I am not sure if I understand you question but...
Each query is distinguished by following property:
- query string itself. Even if two queries is semantically identical,
if upper case/lower case difference or white space is differ, the
two queries are recognized two different queries and the cache entry
will created for two, not one.
- user name. Even if query string is identical, if user is different,
different cache entry will be created.
- database. Even if query string is identical, if database is
different, different cache entry will be created.
- parameter to the query (in extended protocol). Even if query string
is identical, if parameters are different, different cache entry
will be created.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list