How many Mandatory Process are there in Postgres

From: Tadipathri Raghu <traghu(dot)dba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How many Mandatory Process are there in Postgres
Date: 2010-03-25 13:29:37
Message-ID: 645d9d71003250629r22007e0ex9976341e7d155a74@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 the
postgres server and how many sleeping processes are there.

Few important question about Postgres Architecture
======================================
1. When does temp_buffer comes into existence in a database session ( like
when shared_buffer completely filled or any wal_buffer filled) ?
2. What is process array in shared memory?
3. maintenance_work_mem is used for vacuuming(does this memory allocated if
autovacuum is off)?
4. As oracle, Postgres doesnt have any undo_tablespace, for rollback
transaction. But it is handled in BEGIN /END block. So question is where the
transaction data is stored.

Thanks in Advance

Regards
Raghavendra

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tv 2010-03-25 13:58:07 Re: How many Mandatory Process are there in Postgres
Previous Message Devrim GÜNDÜZ 2010-03-25 13:26:25 Re: [GENERAL] pgfoundry registration