From: | jian he <jian(dot)universality(at)gmail(dot)com> |
---|---|
To: | Yi Sun <yinan81(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to know how much CPU, RAM is used by existing 1 database |
Date: | 2022-10-26 10:10:16 |
Message-ID: | CACJufxHSs4Bd9Bksz-Odhoep9NPk-x_mqbSx=VeNt_bYWW=DRA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Oct 26, 2022 at 11:07 AM Yi Sun <yinan81(at)gmail(dot)com> wrote:
> Hi Guys,
>
> Who can help me with this please? I researched but still no result yet,
> thank you
>
> On Tue, 25 Oct 2022 at 16:30, Yi Sun <yinan81(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> There are many databases in our production patroni cluster and it seems
>> it is overloaded, so we decide to migrate the busiest database to a new
>> patroni cluster.
>>
>> pgwatch2 is implemented, how to know how much CPU, RAM is used by the
>> database please? Then we can use it to prepare the new patroni cluster
>> hardware. Thank you
>>
>> Best regards
>> Dennis
>>
>
manual: https://www.postgresql.org/docs/current/runtime-config-resource.html
except min_dynamic_shared_memory (integer)
all other parameters are used to cap the memory. almost all parameters
mentioned "database server" which means it's on cluster level.
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
From | Date | Subject | |
---|---|---|---|
Next Message | Yi Sun | 2022-10-26 14:26:05 | Re: How to know how much CPU, RAM is used by existing 1 database |
Previous Message | Yi Sun | 2022-10-26 05:37:10 | Re: How to know how much CPU, RAM is used by existing 1 database |