[pgpool-general: 7715] Re: Out of memory

[Luiz Pasqual]

We did another test, running a pretty same configuration on pgpool 3.7.3
and it works like described on docs, consuming just a few Mb's.

I'm available to debug, I just need some help on what to do, exactly.



On Fri, Sep 24, 2021 at 9:53 AM Luiz Pasqual <luiz at pasquall.com> wrote:

> Forgot to mention:
>
> We're running 4.2.1, but we've tried 4.2.5 with the same symptoms. It's a
> Linux box, with 4.4.276 kernel.
>
>
>
>
>
> On Fri, Sep 24, 2021 at 9:31 AM Luiz Pasqual <luiz at pasquall.com> wrote:
>
>> Hello,
>>
>> Our pgpool is consuming A LOT of memory and frequently dies with: Out of
>> memory error.
>>
>> We have 2 backends, 1 master and 1 slave. Here some config:
>> num_init_children = 150
>> max_pool = 1
>> child_life_time = 300
>> child_max_connections = 1
>> connection_life_time = 0
>> client_idle_limit = 0
>> connection_cache = on
>> load_balance_mode = on
>> memory_cache_enabled = off
>>
>> RAM: 16Gb
>>
>> Does anyone have a clue what's going on?
>>
>> Thank you.
>>
>> --
>> Luiz Fernando Pasqual S. Souza
>> mail: luiz at pasquall.com
>>
>
>
> --
> Luiz Fernando Pasqual S. Souza
> mail: luiz at pasquall.com
>


-- 
Luiz Fernando Pasqual S. Souza
mail: luiz at pasquall.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210924/81f6f571/attachment.htm>