Re: Lot of postmaster processes - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Lot of postmaster processes
Date
Msg-id CANzqJaC5j6L1Z3=UtPTvUCODmprnmnn=d0tjaUGg6csvh-2MaQ@mail.gmail.com
Whole thread Raw
In response to Lot of postmaster processes  (kaido vaikla <kaido.vaikla@gmail.com>)
Responses Re: Lot of postmaster processes
List pgsql-admin
On Tue, Dec 17, 2024 at 1:42 PM kaido vaikla <kaido.vaikla@gmail.com> wrote:
Hi, 

Output below is output of command
 
$top -c -u postgres

Can somebody tell me why there is so many postmaster running.
O/S: Rocky Linux release 9.4
pg rel:  15.10

    PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND
2837351 postgres  20   0    6408    256    256 D   9.8   0.0   0:02.02 free -h
2837291 postgres  20   0  235300   1536    512 R   2.5   0.0   0:03.34 top -c -u postgres
2837352 postgres  20   0 1257200   2004    128 R   0.8   0.1   0:00.16 /usr/pgsql-15/bin/postmaster -D /pgdata/pgsql/15/data/
2836988 postgres  20   0 1261488  15708  12168 R   0.2   0.4   0:01.01 postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(8497) idle
2836990 postgres  20   0 1261612  14556  11144 R   0.2   0.4   0:01.03 postgres: elvnetfix_instance: elvnetfixadmin elvnetfix x.x.x.x(12454) BEGIN
2837353 postgres  20   0 1257200   1876      0 R   0.2   0.1   0:00.05 /usr/pgsql-15/bin/postmaster -D /pgdata/pgsql/15/data/
[snip] 

What do "pg_ctl -D /pgdata/pgsql/15/data" and "ps -ejH" say?


--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: kaido vaikla
Date:
Subject: Lot of postmaster processes
Next
From: daur exp
Date:
Subject: Re: pg_upgrade utility with --link option