Oracle::PostgreSQL 伺服器基本架構

更新:2007-03-16

對映章節:

內容:
伺服器的 2 個實體(entity)

1. Instance => Postmaster
2. Database => Database

SGA (System Global Area)基本上差異不大, 同樣具有

1. Shared pool
2. Database buffer cache
3. Log buffer

Process

1. SMON => postgres a
   
2. PMON => postgres b
   
3. DBwn => postgres (not limit)
   
4. LGWR => postgres c
5. CKPT => postgres e