[Pgpool-general] memory leak in PgPool II when load is high.

[Ashada Karunaratna]

Hi Yoshiyuki,
   
  Thank you for the reply. The program I am evaluating uses set of web services and it cannot be easily execute without properly setting up the system which may take many hours. This program was running without any issue with Postgres directly for years by now. This system connects to the PgPool controller via a PoolingDataSource() and it should runs for days without restarting the service. Program get the DB connections from the pool using "getConnection()" method of PoolingDataSource and release it with close() method of connection. This way it reuses the connections that were created ealier.
   
  Regards,
   
  ashada
Yoshiyuki Asaba <y-asaba at sraoss.co.jp> wrote:
  Hi,

From: Ashada Karunaratna 
Subject: [Pgpool-general] memory leak in PgPool II when load is high.
Date: Thu, 27 Dec 2007 21:16:31 -0800 (PST)

> However during the evaluation process I could notice that some of PgPool child processes started using very high amount of memory suddenly( more thatn 70 Mb by a process ) causing Linux system to crash due to Swapping. I have below listed an output of Top command sorted by "%Mem" field to provide better understanding on the issue. Acutely I cannot understand why each pgpool process is consuming so much memory. Whole pgpool processes set consumes more memory than Postgres DB at the moment

Could you provide a reproducible program?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp


       
---------------------------------
Looking for last minute shopping deals?  Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20071227/a6c1e719/attachment.html