On Wed, 26 Oct 2022 at 18:10, jian he <jian.universal...@gmail.com> wrote:
> > > On Wed, Oct 26, 2022 at 11:07 AM Yi Sun <yina...@gmail.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 <yina...@gmail.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 > > > Hi Jian he Thank you for your reply The parameters are on cluster level, so we still can not know how much memory is used in a specific database, for example, total memory is 64GB 1. How to get how much memory is used on cluster level? For example 40GB 2. How to get how much memory is used in a specific database? For example 30GB, then we can prepare the new patroni cluster 32GB is enough Thank you Dennis
