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