Re: How to monitor Postgres real memory usage

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: 徐志宇徐 <xuzhiyuster(at)gmail(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: How to monitor Postgres real memory usage
Date: 2022-05-26 23:35:28
Message-ID: 20220526233528.GD19626@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, May 27, 2022 at 01:39:15AM +0800, 徐志宇徐 wrote:
> Hi Justin
>
> Thanks for you explaination.
>
> > > What postgres version ?
> > > How was it installed ? From souce? From a package ?
> I am using Postgres 11.1 .It's installed by package.

This is quite old, and missing ~4 years of bugfixes.

What's the output of these commands?
tail /proc/sys/vm/overcommit_*
tail /proc/sys/vm/nr_*hugepages /proc/cmdline
cat /proc/meminfo
uname -a

--
Justin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alexey Ermakov 2022-05-27 13:39:22 rows selectivity overestimate for @> operator for arrays
Previous Message 徐志宇徐 2022-05-26 17:39:15 Re: How to monitor Postgres real memory usage