From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: y.kikuchi0714@gmail.com
Subject: BUG #17269: Why is virtual memory usage of PostgreSQL growing constantly?
Date: Wed, 03 Nov 2021 11:11:24 +0000
Message-ID: <17269-33419c48264f6532@postgresql.org> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, y.kikuchi0714@gmail.com
Subject: Re: BUG #17269: Why is virtual memory usage of PostgreSQL growing constantly?
In-Reply-To: <17269-33419c48264f6532@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox