Re: BUG #17269: Why is virtual memory usage of PostgreSQL growing constantly?

At Wed, 03 Nov 2021 11:11:24 +0000, PG Bug reporting form <noreply@postgresql.org> wrote in
> The following bug has been logged on the website:
>
> Bug reference:      17269
> Logged by:          Yu Kikuchi
> Email address:      y.kikuchi0714@gmail.com
> PostgreSQL version: 9.6.17
> Operating system:   Windows Server 2016
> Description:       
>
> Hi, our team uses the PostgreSQL 9.6 database.
> A few days ago, we changed memory size because the ratio of memory was about
> 70-80%.
> Accordingly, we changed sharred_buffers in postgresql.conf.
>
> Before
> ・memory:64GB
> ・shared_buffers:16GB
>
> After
> ・memory:128GB
> ・shared_buffers:32GB
>
> The radio of memory is about 20% after we changed memory size, but
> PostgreSQL uses virtual memory constantly.
> PostgreSQL finally ran out of virtual memory a few hours later.
> Why did PostgreSQL use virtual memory although there is an available memory?

Could you show us some settings?  Maybe max_connections and work_mem
could be the starter.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center