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
>
>
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 |