[pgpool-general: 798] Re: relcache_size in pgpool-II 3.2RC1

[Lazáro Rubén García Martínez]

Tatsuo, attached are the pgpool.log and pgpool.conf file.

Did you see the last mail related with on memory query cache, and the wrong behavior when a comment is writen in from of the query?

Regards.

________________________________________
From: Tatsuo Ishii [ishii at postgresql.org]
Sent: Monday, July 23, 2012 5:43 PM
To: Lazáro Rubén García Martínez
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 792] relcache_size in pgpool-II 3.2RC1

Ca you show me the pgpool log which log_per_node_statement enabled?  I
need full log, from the point when client connects, to the timing when
"pool_search_relcache: cache replacement happend".
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> The problem is that I have incremented this value to high (3000) however in the log file this messages persists.
>
> "pool_search_relcache: cache replacement happend"
>
> Regards.
> ________________________________________
> From: Tatsuo Ishii [ishii at postgresql.org]
> Sent: Sunday, July 22, 2012 11:36 PM
> To: Lazáro Rubén García Martínez
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 792] relcache_size in pgpool-II 3.2RC1
>
>> Hello everyone in the list.
>>
>> Is there any method for configuring the property relcache_size? How can I determinate this value?
>
>>From pgpool.conf.sample:
>
> relcache_size = 256
>                                    # Number of relation cache
>                                    # entry. If you see frequently:
>                                    # "pool_search_relcache: cache replacement happend"
>                                    # in the pgpool log, you might want to increate this number.
>
> So you should check out the log message in pgpool.log.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com
>
> Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
> http://www.antiterroristas.cu
> http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.rar
Type: application/octet-stream
Size: 134874 bytes
Desc: pgpool.rar
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120723/7ed95c1d/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 25439 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120723/7ed95c1d/attachment-0003.obj>