Gyln, Thanks. I happened to read through the thread after posted the mail. It seems like I have to stick with Pgpool I until the developer is free.
-- takizo On Sep 7, 2011, at 10:53 PM, Glyn Astill wrote: > Hi takizo, > > Yes this bug has been seen by numerous people on the list, Yoshiyuki Asaba > has posted a patch, however there has been no response from the main Pgpool > II developers. > > I did ask a few times, and also asked if we'd be better testing 3.1, but alas > still no response. I can only assume the devs are busy or otherwise > indisposed. > > See the thread below for the patch. > > http://www.mail-archive.com/[email protected]/msg03141.html > > Glyn > > From: takizo <[email protected]> > To: [email protected] > Sent: Wednesday, 7 September 2011, 15:02 > Subject: [Pgpool-general] Pgpool I vs Pgpool II > > Hi all, > > Today I have upgraded Pgpool I to Pgpool II. And I had to roll back to Pgpool > I due to memory hunger issue. > > My server is configured with > PostgreSQL 8.2, > running on FreeBSD 8.2 > Intel Xeon box with 4 CPUs with Quad Core, total of 16 cores > Memory with 24GB > > * While running on Pgpool I > I do no have memory hunger issue. On postgresql.conf, I have > max_connections=200 and shared_buffers=2GB. > Most of the time, I have 8GB memory in used and 10GB Free and some in cached. > Everything run just fine and perfectly good. > > * I tried upgraded to Pgpool II > Same config on postgresql.conf, when I started PgPool II (3.0.4), my active > memory started increasing and it didn't drop at all. > I left the server running and after about 20 minutes, 20GB memory is in used, > ended up it used swap memory because running out of memory. > > I run a reload/restart on pgpool, I gained back 14GB of free memory, and > slowly it started to taken up those freed memory in active memory after about > 15-20 minutes. > I tried to bring down max_connections and shared_buffers value, and the > memory doesn't stop taking up. It still slowly gaining all the memory it > wants. > > Has anyone having that problem as well? I hope I can find some answer here :) > Wanted to try out pgpool II performance but this problem is the stopper for > now. > > Hope to get feedback from gurus in the house. > > Thanks! > > -- > takizo > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
