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

[Tatsuo Ishii]

>> Tatsuo, attached are the pgpool.log and pgpool.conf file.
> 
> Thanks. Will look into this.

It appeared that there was a "false alarm" of "pool_search_relcache:
cache replacement happend". Please apply included patch. If you still
see the message, please let me know and send me pgpool log.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

>> 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?
> 
> Yes, and Nozomi Anzai is on working on this.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
> 
>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
A non-text attachment was scrubbed...
Name: relcache.patch
Type: text/x-patch
Size: 825 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120724/1762e79a/attachment.bin>