[pgpool-general: 8535] Re: Cache configuration

[Avi Raboah]

I’ll try to clarify the question.

I saw that when I query lets say a result with 10k records I saw that num
entry used increased by 5 when I expected to increase by 1.

So I asked if is it possible that a query result will allocate more than
one entry?

Thanks,

Avi.



On Tue, 3 Jan 2023 at 11:19 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230103/1654e05b/attachment.htm>