In response to Ashada Karunaratna <[EMAIL PROTECTED]>: > > 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? > > 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.
I believe you misunderstood Yoshiyuki's question. Without a reproducible test case, it's unlikely that anyone will be able to help you. If you want to help fix this, you're going to have to provide a lot more detail, and a program that reproduces the problem is the easiest way to do so. -- Bill Moran Collaborative Fusion Inc. http://people.collaborativefusion.com/~wmoran/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
