Re: memory consumption of memory for postgres db container

From: Ninad Shah <nshah(dot)postgres(at)gmail(dot)com>
To: M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: memory consumption of memory for postgres db container
Date: 2021-09-02 19:38:40
Message-ID: CAOFEiBefw8r4cGE7vXP_a3P=vpn_j4Zr-wgrRsH+rLurLviC1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You may checkout using "free -m" and may see how much memory is cache.

If you are using RHEL, you may clear cache using below commands.

sync; echo 1 > /proc/sys/vm/drop_caches; sync

Though this is going to release some memory from the cache, it may fill up
the cache again.

Regards,
Ninad Shah

On Thu, 2 Sept 2021 at 20:41, M Tarkeshwar Rao <
m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> wrote:

> Can you please suggest few commands?
>
>
>
> Regards
>
> Tarkeshwar
>
>
>
> *From:* Ninad Shah <nshah(dot)postgres(at)gmail(dot)com>
> *Sent:* Thursday, September 2, 2021 8:30 PM
> *To:* M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>
> *Cc:* pgsql-general(at)postgresql(dot)org
> *Subject:* Re: memory consumption of memory for postgres db container
>
>
>
> No need to worry. This isn't really a concern.
>
>
>
> No operating system releases memory upon using it, but caches it once the
> program finishes. This actually saves time as memory blocks can be
> allocated in less time than loading new blocks.
>
> However, if it's required to release memory, it can be performed via a few
> commands.
>
>
>
>
>
> Regards,
>
> Ninad Shah
>
>
>
> On Thu, 2 Sept 2021 at 20:05, M Tarkeshwar Rao <
> m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> wrote:
>
> Hi all,
>
>
>
> We did a stability test for our product, where we continuously inserting
> data into postgres tables. We did this for three days continuously.
>
> Memory utilization of our Postgres container continuously increasing.
>
>
>
>
>
> Can you please provide us the clue why it is not constant and continuously
> increasing?
>
>
>
> Regards
>
> Tarkeshwar
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ninad Shah 2021-09-02 19:42:16 Re: Querying a table with jaccard similarity with 1.6 million records take 12 seconds
Previous Message David G. Johnston 2021-09-02 19:16:18 Re: Upgrade 9.5 cluster on Ubuntu 16.04