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

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

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

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

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.

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

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: How to load data from CSV into a table that has array types in its columns?

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 [

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

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: Multi master disjoint cluster

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

Multi master disjoint cluster

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: How to know how much CPU, RAM is used by existing 1 database

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

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

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

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

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

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