Обсуждение: RE: Multiple Postgres process are running in background
Hi,
We are using Postgres 10 (Single client)and observed that there are multiple PostgreSQL Server process are running in background.
Why these additional process are created or is this an expected behavior.
Regards,
RamCharan
Вложения
On 8/13/21 3:20 AM, Ram Charan Kallem wrote: > Hi, > > We are using Postgres 10 (Single client)and observed that there are > multiple PostgreSQL Server process are running in background. > > Why these additional process are created or is this an expected behavior. Yes. From my Linux machine: ps ax | grep postgres 818 ? Ss 0:00 /usr/local/pgsql12/bin/postgres -D /usr/local/pgsql12_test/data 906 ? Ss 0:00 /usr/local/pgsql12/bin/postgres -D /usr/local/pgsql12/data 954 ? Ss 0:00 postgres: logger 982 ? Ss 0:00 postgres: logger 984 ? Ss 0:00 postgres: checkpointer 985 ? Ss 0:00 postgres: background writer 986 ? Ss 0:00 postgres: walwriter 987 ? Ss 0:00 postgres: autovacuum launcher 988 ? Ss 0:00 postgres: stats collector 989 ? Ss 0:00 postgres: logical replication launcher 1001 ? Ss 0:00 postgres: checkpointer 1002 ? Ss 0:00 postgres: background writer 1003 ? Ss 0:00 postgres: walwriter 1004 ? Ss 0:00 postgres: autovacuum launcher 1005 ? Ss 0:00 postgres: stats collector 1006 ? Ss 0:00 postgres: logical replication launcher 7204 pts/0 S+ 0:00 psql -d test -U postgres 7205 ? Ss 0:00 postgres: postgres test [local] idle 7250 pts/1 S+ 0:00 psql -d production -U postgres -p 5442 7251 ? Ss 0:00 postgres: postgres production [local] idle 7296 pts/2 S+ 0:00 grep --color=auto postgres There are background processes that run as well as process for each connection. > > Regards, > > RamCharan > -- Adrian Klaver adrian.klaver@aklaver.com
Em sex., 13 de ago. de 2021 às 11:55, Ram Charan Kallem <RamCharan.Kallem@non.se.com> escreveu:
Hi,
We are using Postgres 10 (Single client)and observed that there are multiple PostgreSQL Server process are running in background.
Why these additional process are created or is this an expected behavior.
This is a normal and expected behavior.
regards,
Ranier Vilela
Em sex., 13 de ago. de 2021 às 11:55, Ram Charan Kallem <RamCharan.Kallem@non.se.com> escreveu:
Hi,
We are using Postgres 10 (Single client)and observed that there are multiple PostgreSQL Server process are running in background.
Why these additional process are created or is this an expected behavior.
This is a normal and expected behavior.
regards,
Ranier Vilela