[pgpool-general: 8534] Re: Cache configuration

[Tatsuo Ishii]

> 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