Re: [GENERAL] How many Mandatory Process are there in Postgres

Le 28/03/2010 19:30, Scott Marlowe a écrit : > On Sun, Mar 28, 2010 at 1:14 AM, Tadipathri Raghu > wrote: >> Hi All, >> >> Thank you for the prompt reply on this. >> >> Please find the output of the top command and the process availabe. Could >> explain what logger process is here for > > Loggin

Re: [GENERAL] How many Mandatory Process are there in Postgres

On Sun, Mar 28, 2010 at 1:14 AM, Tadipathri Raghu wrote: > Hi All, > > Thank you for the prompt reply on this. > > Please find the output of the top command and the process availabe. Could > explain what logger process is here for Logging? I'm just guessing there. My machines don't have it and

Re: [GENERAL] How many Mandatory Process are there in Postgres

Hi All, Thank you for the prompt reply on this. Please find the output of the top command and the process availabe. Could explain what logger process is here for top - 12:41:57 up 17:51, 3 users, load average: 0.00, 0.04, 0.01 Tasks: 141 total, 1 running, 139 sleeping, 0 stopped, 1 zombi

Re: [GENERAL] How many Mandatory Process are there in Postgres

On Thu, Mar 25, 2010 at 9:03 PM, Tadipathri Raghu wrote: > Hi Scott, Thomas, > > Thank you for the update. > >> >> >> Oracle uses a completely different implementation of MVCC architecture. >> >> It >> >> overwrites the data and then uses rollback segments to provide >> >> 'previous >> >> versions

Re: [GENERAL] How many Mandatory Process are there in Postgres

> > Hi Scott, Thomas, Thank you for the update. > >> Oracle uses a completely different implementation of MVCC > architecture. > >> It > >> overwrites the data and then uses rollback segments to provide 'previous > >> versions' to running transactions etc. > >> > >> PostgreSQL does not overwrit

Re: [GENERAL] How many Mandatory Process are there in Postgres

2010/3/25 > >> Oracle uses a completely different implementation of MVCC architecture. > >> It > >> overwrites the data and then uses rollback segments to provide 'previous > >> versions' to running transactions etc. > >> > >> PostgreSQL does not overwrite the data - it just creates a copy of

Re: [GENERAL] How many Mandatory Process are there in Postgres

> Hi Tomas, > > Thank you for the reply. > > >> Well, there is a bunch of processes started at the beginning, and then >> there is one backend process for each connection (see the >> postgresql.conf >> how many connections are allowed in your case). >> > I do agree with you, that there would be bu

Re: [GENERAL] How many Mandatory Process are there in Postgres

Hi Tomas, Thank you for the reply. > Well, there is a bunch of processes started at the beginning, and then > there is one backend process for each connection (see the postgresql.conf > how many connections are allowed in your case). > I do agree with you, that there would be bunch of process.

Re: [GENERAL] How many Mandatory Process are there in Postgres

> Hi All, > > When we start the postgres server, the writer process, wal process, > postmaster, autovacuum ( if autovacuum is on), stats collector will come > into picture as mandotory process. My question is, is there any processes > apart from these process, what are the mandotory process come al

[GENERAL] How many Mandatory Process are there in Postgres

Hi All, When we start the postgres server, the writer process, wal process, postmaster, autovacuum ( if autovacuum is on), stats collector will come into picture as mandotory process. My question is, is there any processes apart from these process, what are the mandotory process come along with th