Hi takizo,
We are currently using Pgpool-II 2.3.3 and it has been really stable for us.
Unless you're after a specific feature in Pgpool-II 3.x you could perhaps try
it?
So far I've had no luck with the patch posted by Yoshiyuki, even with that
patch there is still a massive memory leak in 3.0.4. It would appear that
pool_proto_modules.c has lots commented out calls to free_parser(), many more
than the single case that Yoshiyuki uncommented with his patch, so either there
is a bit of a mess there that needs sorting out by someone who knows the
overall logic, or the issue is elsewhere.
Glyn
>________________________________
>From: takizo <paul...@takizo.com>
>To: Glyn Astill <glynast...@yahoo.co.uk>
>Cc: "pgpool-general@pgfoundry.org" <pgpool-general@pgfoundry.org>
>Sent: Thursday, 8 September 2011, 1:48
>Subject: Re: [Pgpool-general] Pgpool I vs Pgpool II
>
>
>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/pgpool-general@pgfoundry.org/msg03141.html
>>
>>Glyn
>>
>>
>>
>>>________________________________
>>>From: takizo <paul...@takizo.com>
>>>To: pgpool-general@pgfoundry.org
>>>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
>>>Pgpool-general@pgfoundry.org
>>>http://pgfoundry.org/mailman/listinfo/pgpool-general
>>>
>>>
>>>
>
>
>
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general