Hi, From: Ashada Karunaratna <[EMAIL PROTECTED]> Subject: Re: [Pgpool-general] memory leak in PgPool II when load is high. Date: Thu, 27 Dec 2007 22:37:38 -0800 (PST)
> 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. Can you show us a sample program using PoolingDataSource? Regards, -- Yoshiyuki Asaba [EMAIL PROTECTED] > > Regards, > > ashada > Yoshiyuki Asaba <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > > > --------------------------------- > Looking for last minute shopping deals? Find them fast with Yahoo! Search. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
