Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread jian he
On Wed, Oct 26, 2022 at 11:07 AM Yi Sun 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 wrote: > >> Hi, >> >> There are many databases in our production patroni cluster and it seems >> it is overlo

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Yi Sun
On Wed, 26 Oct 2022 at 18:10, jian he wrote: > > > On Wed, Oct 26, 2022 at 11:07 AM Yi Sun 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 wrote: >> >>> Hi, >>> >>> There are many database

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Rob Sargent
On 10/26/22 08:26, Yi Sun wrote: On Wed, 26 Oct 2022 at 18:10, jian he wrote: On Wed, Oct 26, 2022 at 11:07 AM Yi Sun 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 Su

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Atul Kumar
I hope the below link helps... https://www.enterprisedb.com/blog/monitor-cpu-and-memory-percentage-used-each-process-postgresqlppas-91 On 10/26/22, Rob Sargent wrote: > On 10/26/22 08:26, Yi Sun wrote: >> >> >> On Wed, 26 Oct 2022 at 18:10, jian he >> wrote: >> >> >> >> On Wed, Oct 26, 2022

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Laurenz Albe
On Wed, 2022-10-26 at 13:37 +0800, Yi Sun wrote: > 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 wrote: > > Hi, > > > > There are many databases in our production patroni cluster and it seems it > > is overloaded, >

Multi master disjoint cluster

2022-10-26 Thread Vijaykumar Jain
Hi all, tl;dr I have a simple question, given a choice if I can write the same data to two databases in parallel, should I opt for primary / replica setup or multi writer/master setup. This setup has the ability to make use of kafka consumer groups (like two replication slots each having their own

Re: Multi master disjoint cluster

2022-10-26 Thread Vijaykumar Jain
Actually, pls ignore my email. re reading my mail makes it look like I did not research it throughly and just asked without actual implementation of both options and having a clear goal on what can incompromise along with no read downtime. I'll write better next time. On Wed, Oct 26, 2022, 10:04

How to load data from CSV into a table that has array types in its columns?

2022-10-26 Thread Siddharth Jain
Hello, Given a long list like this: 1,2 2,4 --> 2 appears once 7,9 8,9 5,3 2,5 --> note 2 appears twice I want to load it into this table: create table tbl ( id integer primary key, fids integer[] ) so we will have 2 -> [4,5] where 2 is id and [4,5] are the fids My actual dataset is very

Re: How to load data from CSV into a table that has array types in its columns?

2022-10-26 Thread Adrian Klaver
On 10/26/22 17:30, Siddharth Jain wrote: Hello, Given a long list like this: 1,2 2,4 --> 2 appears once 7,9 8,9 5,3 2,5 --> note 2 appears twice I want to load it into this table: create table tbl (   id integer primary key,   fids integer[] ) so we will have 2 -> [4,5] where 2 is id and [

Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread Bryn Llewellyn
The descriptive designation "the role that owns the SQL part of the implementation of PostgreSQL" is too much of a mouthful for daily use. And anyway, this notion captures only part of the story that makes "postgres" uniquely what it is—at least on Ubuntu. MORE... Here's what my empirical obs

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread David G. Johnston
On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: > The descriptive designation "the role that owns the SQL part of the > implementation of PostgreSQL" is too much of a mouthful for daily use. > Don't think it's documented but I like "bootstrap user" which I've seen bandied about here a bit.

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread Ian Lawrence Barwick
2022年10月27日(木) 11:00 David G. Johnston : > > On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: >> >> The descriptive designation "the role that owns the SQL part of the >> implementation of PostgreSQL" is too much of a mouthful for daily use. > > > Don't think it's documented but I like "boot

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread Misty Peters (MistyLynn)
Can you stop sending me message idk why I need my email back thanks Sent from my iPhone > On Oct 26, 2022, at 7:11 PM, Ian Lawrence Barwick wrote: > > 2022年10月27日(木) 11:00 David G. Johnston : >> >>> On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn wrote: >>> >>> The descriptive designation "

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

2022-10-26 Thread Adrian Klaver
On 10/26/22 18:33, Bryn Llewellyn wrote: The descriptive designation "the role that owns the SQL part of the implementation of PostgreSQL" is too much of a mouthful for daily use.  And anyway, this notion captures only part of the story that makes "postgres" uniquely what it is—at least on Ubu